Hi All,
I have one typical task which need to complete by using macro.
I have around 100's of excel files (note each file has only one sheet but names differs from file to file). I want to copy the each file sheet and paste it in master sheet and it should get paste one by one as like for example if you paste cells till A20 then next copy should start from A22 (one row should be empty from one file data to another).
The macro should automatically open the file and copy the data and paste it into master sheet then it should close. So, that I can use this to complete the all files.
Your inputs on this very helpful for me.
Thank you.
I have one typical task which need to complete by using macro.
I have around 100's of excel files (note each file has only one sheet but names differs from file to file). I want to copy the each file sheet and paste it in master sheet and it should get paste one by one as like for example if you paste cells till A20 then next copy should start from A22 (one row should be empty from one file data to another).
The macro should automatically open the file and copy the data and paste it into master sheet then it should close. So, that I can use this to complete the all files.
Your inputs on this very helpful for me.
Thank you.
