Chupis
New Member
- Joined
- Jan 25, 2005
- Messages
- 16
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!
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!