Thanks Rajeev for your reply. I think my question was too general. What I have is one spreadsheet with three pages. Page one contains peoples' names, contact details etc, collected before 5 Sept 2007; page two the same but collected between 5 Sept and 31 Dec; page three 1 Jan onwards.

I need to keep these pages separate but also have one list in which all the 150 + entries are integrated.

The three pages already have the same layout. The entries are for academics listed under subject area, which is the heading of column A. Some of them have more than one subject area and so make multiple appearances on the list - this should be preserved in the integrated list.

Can you help?

Thanks
Linda

PS I hope you got your phone back.

Hi Linda,
I hope you don't mind me answering on Rajeev's behalf.

Presuming the data does not change on sheets 1 or 2, and perhaps only changes on sheet 3, I think the answer to this may be relatively simple. On the worksheet where you want to hold the entire list of 150+, set the headings to mirror those of the other worksheets. Then in the first blank cell, type and equal sign, then use your mouse to choose the first cell with data in the first worksheet, and hit the enter key. You can then use your mouse to copy the data down and across (hover your mouse over the bottom right of the cell that you want to copy, until your pointer becomes a plus sign, then click and drag your mouse down, and then across). Once you have copied the data from sheet 1, you can start at the first blank cell, and copy the data from sheet 2 in the same manner.

Will this help with what you are trying to do? If it doesn't, please feel free to reply to this message with any further details you may have, and I will be glad to assist more. If it does resolve your question, could you please mark your question as "resolved"?

Have a great day.

Kind regards,
Mara
Microsoft Office Specialist Master Trainer