W
windslayer
Hi All VBA experts:
I have 1000+ data files stored in csv. All of these files have the sam
structure& format.
I use a vba code written by abousetta
To merge it into one spreadsheet automatically, but the problem is,th
data i needed start only from row 11 onward.
Is there a way to modify the code to allow this to happen?
Here's my requirement on the code:
1) Must be able to merge all the file csv file in on shoot,
2) Data needed start from 11th row onward,
3) after open each file, copy the data from 11th row and onward, cop
and paste it into MasterCSV sheet, the next data will be paste to th
same column but next row to the previous data copied...
I attach one of my file into the thread...
I have 1000+ data files stored in csv. All of these files have the sam
structure& format.
I use a vba code written by abousetta
To merge it into one spreadsheet automatically, but the problem is,th
data i needed start only from row 11 onward.
Is there a way to modify the code to allow this to happen?
Here's my requirement on the code:
1) Must be able to merge all the file csv file in on shoot,
2) Data needed start from 11th row onward,
3) after open each file, copy the data from 11th row and onward, cop
and paste it into MasterCSV sheet, the next data will be paste to th
same column but next row to the previous data copied...
I attach one of my file into the thread...