Hi,

I hope someone can help...I've been searching google for days now to no avail!

Basically, I have a number of CSV files in folder C:/Data, each of these CSV file contains transactions that I want to split into different sheets on this workbook according to accounts.

There are a number of accounts from the file but i only need 9 of however many.

In a nutshell, I need to consolidate all the data from the CSV files and the create a new worksheet (in existing workbook) for each of the nine accounts and copy all the data from the CSV files to it.


Thanks in advance for any help...

Eric