Hi I have three files.
Now my requirement is
first I have to open the File1.csv and select the complete 11th row. Click on the particular Type column and filter it. Once filter I have to copy the data from the 12th row till the end. And then past in the Master_File.xlsm in the particular sheet from line number 12th only.
Again I have to read the File2.csv select the complete 11th row filter the particular Type column same as we did in File1.csv and copy the data from the 12th row till end and paste the data in the same Master_File.xlsm but this time I have start the data pasting from where File1.csv data is done.
As I have started the data pasting from 12th row and it pasted the 10 lines data Now I have total 22 rows right. So I want my data paste of File2.csv from 23th row.
Kindly suggest me how can I do this…