Macros to Organize the Data from multiple files to one file

T

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum work hours to hours & nearest 10th of an hour 14
Failed to add footer one of work sheet, Thanks 3
Import multiple workbooks to current workbook in specified row number 0
Finding Characters in a String 8
Populating a check sheet from a frequency table 1
Would like to create customized named range 2
Query from Multiple Workbooks 4
Divide two numbers in data subtotal function 2

Top