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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"TEAM" wrote in message
...

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

Because Units are grouped by location, I end up with about 7 different
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 that
folder.


PROBLEM: I would like to have the information organized according to
unit name instead of by month. Ideally, this would be one file with a
sheet for every unit. The sheets would be labelled 'Unit A'...'Unit
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 that
folder, match the names in column A to the unit names listed on each
sheet, and paste the corresponding row of data (columns B through W) on
the first available row??


--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=388480