software

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.

Month 1
Month 2
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

Dawn
Without resorting to VBA, we suggest:

sort each sheet by ID;
copy ID column only of all 12 sheets;
inspect the 12 columns, insert blank cells to line up ID across rows;
insert equal number of rows as cells in relevant sheets;
now copy as you wished

quot;Dawn Williamsquot; lt;Dawn gt; wrote in message
...
gt; I have a spreadsheet containing 12 worksheets. The worksheets have
several
gt; columns of information against a record which has a unique staff number.
gt;
gt; e.g. Worksheet (Month 1)
gt;
gt; ID No Amount Amount Amount
gt;
gt; I would like to create a master spreadsheet which contains each unquie ID
gt; number against each month's information. E.g.
gt;
gt; Month 1
gt; Month 2
gt; ID No Amount1 Amount2 Amount3 Amount1 Amount2 Amount3
gt;
gt; Is there anyway I can pull the information against each ID number onto one
gt; sheet (as above). I cannot copy and paste from one to another because I
have
gt; leavers and joiners so they don't always match up.
gt;
gt; I would be gratefuly for any help. Many thanks
gt;
gt; Dawn
gt;
gt;