Hi everyone,
How do I copy data from a closed workbook and paste it on a open workbook(where the macro is) while pasting the copied values in a new row and not deleting or overwriting the data present below that.
For example, here is how the source file looks:
src.png
the blank result file looks like:
res.png
wanted result:
exp.png
Code I've done:
which gives the below results:Please Login or Register to view this content.
wrg.png
Pls help.
NOTE: I also want to get the data ranges dynamically instead of hardcoding(like "B3:B12", "C3:C12" etc) as the data range for different source file may vary.
Bookmarks