manipulating data before importing it

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!
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Egress1

Active Member
Joined
Mar 2, 2003
Messages
420
Chupis said:
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,463
Messages
5,596,284
Members
414,051
Latest member
tabecker

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top