Question

  • Creator
    Topic
  • #2154200

    How to Consolidate Several Excel Files into One

    Locked

    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?

    Thanks!

All Answers

Viewing 1 reply thread