How to Consolidate Several Excel Files into One

By PlexusSage ·
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?


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums