need to automate the process where in i am currently copy paste the data from one file to another file.
Needed in macro.
1. Select the file that needs to copied (Source File).
2. Copy the all the cells, which have data.
3. Open the Destination File, last + 1 row & paste the...