Hi All VBA experts:
I have 1000+ data files stored in csv. All of these files have the same
I use a vba code written by abousetta
To merge it into one spreadsheet automatically, but the problem is,the
data i needed start only from row 11 onward.
Is there a way to modify the code to allow this to happen?
Here is 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, copy
and paste it into MasterCSV sheet, the next data will be paste to the
same column but next row to the previous data copied...
I attach one of my file into the thread...