Hi
I need a macro to open the browse window and enable me to choose the file i want to open. Then copy the specific worksheet(entire) from recently opened excel spreadsheet to the macro file. I want this to be done for 3 files so I would need a loop function as well.
Please help me as I am unable to set up the correct VBA code in this respect.
Thanks in advance.
