|Subject:||How can I create a master spreadsheet from different workbooks|
|Posted by:||Dawn Williams|
|Date:||Wed, 3 May 2006|
I have a spreadsheet containing 12 worksheets. The worksheets have several
columns of information against a record which has a unique staff number.
e.g. Worksheet (Month 1)
ID No Amount Amount Amount
I would like to create a master spreadsheet which contains each unquie ID
number against each month's information. E.g.
ID No Amount1 Amount2 Amount3 Amount1 Amount2 Amount3
Is there anyway I can pull the information against each ID number onto one
sheet (as above). I cannot copy and paste from one to another because I have
leavers and joiners so they don't always match up.
I would be gratefuly for any help. Many thanks