Macros to Organize the Data from multiple files to one file

[TEAM]

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??

[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

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


"TEAM" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>