Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I organize data from excel 2003 database into a word file? | New Users to Excel | |||
print files & subfiles fo we can organize them | Excel Worksheet Functions | |||
Extract Data From Multiple Excel Files - One File | Excel Programming | |||
How do I pull data from multiple files and copy into one file | Excel Programming | |||
How to group or organize dozens of macros? | Excel Programming |