merging data from multiple excel spread sheets

Hi There,

I have a number of excel spread sheets that are identical apart from the data in the populated colums, what i would like to know is, can i merge all these sheets together and have one sheet?

If this is possible how do i do it

Many thanks

Hi,

You do not mention a lot of specifics about your problem, but I would recommend you take at look at consolidation ...
Data Pivot Table Multiple Consolidation ranges

HTH
Carim

To merge multiple sheets you must 'Share' the workbook first. After having shared the workbook, when other users make additions or changes in a copy of the shared workbook you can consolidate these into a single workbook. To do so you will need copy all of the 'cloned' sheets into a folder (with different names than your 'master' sheet) and then choose the "Consolidate and Merge" feature.

You can then review and accept some or all of the changes that you have merged from the cloned sheets.

SAR