Macros to Organize the Data from multiple files to one file
 

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?

--
TEA
-----------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...fo&userid=2281
View this thread: http://www.excelforum.com/showthread.php?threadid=38848

Macros to Organize the Data from multiple files to one file
 

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