Question Locked

How to Consolidate Several Excel Files into One

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I 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!

2 replies

This discussion is closed to new replies.