Aggregate and Organize from Multiple Files

The Food Science department uses a piece of equipment that analyzes different foods and creates hundreds of CSV files of output Each CSV is placed in a folder by the machine. For many months they have paid students to do the following:

• Open the folder containing the CSV.
• Open the CSV.
• Go to the last worksheet.
• Copy the entire range (three separate ranges)
• Paste the range in another worksheet
• and then repeat the process for hundreds and hundreds of folders.

My project automates this process, shortening the amount of time from 30 hours to 2 seconds, and reducing the chance of error.

Output Files From Machine (must be unzipped)

Excel Aggregator (thoroughly documented code)

Writeup