obriensj
08-20-2008, 02:14 AM
Hi,
Not sure if this can be done but thought I would ask anyway!
I need to be able to open up numerous csv files everyday and copy the contents, minus the header row into a master spreadsheet everyday.
The issue being that everyday the amount of data in these csv files will never be the same. The columns will though, A:S for example
For instance on Monday there may be 50 rows in one file, 70 in the next csv file and say 5 in the next csv file and so on.
On Tuesday there could be 35 rows, 40 in the next and say 10 in the next one.
I need some bit of code that will copy the contents (not the header row) of these csv files into the master spreadsheet and then sort the master spreadsheet by column A.
So on Monday there could be a total of 300 rows, Tuesday a total of 550 rows and so on.
The problem as I see it is that I cannot record a macro to do this because each day I don?t know how many rows I will be copying over into the master spreadsheet and as such I would need to leave a gap of say 5000 rows before I paste in the next csv file which is not really workable.
Any ideas?
Thanks
Not sure if this can be done but thought I would ask anyway!
I need to be able to open up numerous csv files everyday and copy the contents, minus the header row into a master spreadsheet everyday.
The issue being that everyday the amount of data in these csv files will never be the same. The columns will though, A:S for example
For instance on Monday there may be 50 rows in one file, 70 in the next csv file and say 5 in the next csv file and so on.
On Tuesday there could be 35 rows, 40 in the next and say 10 in the next one.
I need some bit of code that will copy the contents (not the header row) of these csv files into the master spreadsheet and then sort the master spreadsheet by column A.
So on Monday there could be a total of 300 rows, Tuesday a total of 550 rows and so on.
The problem as I see it is that I cannot record a macro to do this because each day I don?t know how many rows I will be copying over into the master spreadsheet and as such I would need to leave a gap of say 5000 rows before I paste in the next csv file which is not really workable.
Any ideas?
Thanks