Macros to Organize the Data from multiple files to one file

[TEAM]

BACKGROUND: Every month I run a report that performs calculation
related to the equipment I am operating. The third party progra
performing these calculations then generates an excel output that list
every unit name in column A and the corresponding output data in column
B through W.

Because Units are grouped by location, I end up with about 7 differen
excel output files, each containing a list of 1 to 25 units.

Every month I create a new folder and store these 7 files in tha
folder.


PROBLEM: I would like to have the information organized according t
unit name instead of by month. Ideally, this would be one file with
sheet for every unit. The sheets would be labelled 'Unit A'...'Uni
B'...etc. (The names would be identical to those listed in column A
mentioned in paragraph 1 above).


QUESTION: What module/macro would prompt me to select a folder (ex
'June 05'), and then it would individually open all 7 files within tha
folder, match the names in column A to the unit names listed on eac
sheet, and paste the corresponding row of data (columns B through W) o
the first available row?

 

[Ron de Bruin]

Hi Team

To put them all in one sheet
http://www.rondebruin.nl/copy3.htm

Then to create seperate sheets
http://www.rondebruin.nl/copy5.htm

If you need more help post back