Hi
My Question is similar to this thread.
https://www.excelforum.com/excel-pro...-workbook.html
I have one master excel file namely Master Data.xls.
I need to open some other excel files one by one. (Manual only) then i need to copy Active sheet of whatever files i opened, to Active sheet of Master Data.xls then whatever file i opened that should be closed. (Not Master Data.xls)
The range and format should be as how it was in the opened workbook.
I tried the above thread code but its working vice versa
Can someone help me to modify the code.
Bookmarks