manipulating data before importing it

[Chupis]

Oure systems create several csv files daily; all of them contain only raw data. The task is to create one central spreadsheet with only the totals of each individual csv file. The files themselves use a time stamp as the file name so it’s simple to track and sort. The problem I have and need help with is how do I open the csv file from an excel spreadsheet, manipulate data (calculate totals), and list the results back on the spreadsheet.

I know how to retrieve data from another spreadsheet. I just don’t know how (or if it’s possible) to manipulate the data first before importing it. I’ve been using VBA to track the csv files.

It would be fabulous if anyone can point in the right direction!

 

[Egress1]

Oure systems create several csv files daily; all of them contain only raw data. The task is to create one central spreadsheet with only the totals of each individual csv file. The files themselves use a time stamp as the file name so it’s simple to track and sort. The problem I have and need help with is how do I open the csv file from an excel spreadsheet, manipulate data (calculate totals), and list the results back on the spreadsheet.

It would be fabulous if anyone can point in the right direction!

How large are the csv files? You can open your files with VBA code. Do your manipulations and calculations within the code then print out only the results you want onto the appropriate spread sheets.