I want to create a macro where user can key in the path of another excel workbook and sheet name, and copy over that entire sheet into this workbook.
eg. A1 = file path = "C:\Temp\test.xlsx"
B1 = sheet name = "Main"
I have tried many method, but none is working for me..
Can you help?