Compare and Merge

[markysparky]

I have around 30 wookbooks (2003) which are not shared but they are the same (tabs columns same but number of rows are different in each tab). What is the best way to merge / copy,paste these into one. They are all in the same folder. I just need all the data from these workbooks into one

Your suggestions please

Mark

[Alf]

Perhaps a macro like this?

Please Login or Register  to view this content.

This macro runs from a master file i.e. "Master_wkb.xls". As this name is hardcoded in the macro you must change the code if you wish for another file name. The macro search for the excel files in the folder c:\Test so you need to change that to wherever your files is found. I've also assumed that all files in that folder is files you whish to extract data from.

I my example I also assumes that each file contains 3 worksheets. If not so you must change the line

Please Login or Register  to view this content.

to an appropriate number.

The macro copies all information from the first sheet in the first found file and pastes this information to the first sheet in "Master_wkb.xls" moves on to the next sheet in the first found file, copies and pastes in to second sheet in "Master_wkb.xls" and so forth.

As soon as all sheets are processed in a found file this file is closed and the next one is opened.

Alf