Question
-
Topic
-
How to Consolidate Several Excel Files into One
LockedI have several retail locations that will automatically generate a report and dump it to a CSV file. I wrote a batch file to automatically upload the files to my FTP server at the main office. Now I want to automatically get those CSV files into one workbook with each location’s report in its own worksheet.
We are on Excel 2007.Any tips?
Thanks!
All Answers
Viewing 1 reply thread