Hi
I need Macro that can copy ranges from 2 workbooks that are 'closed'. Their Address on PC D:\EXCEL FORUM\Book1.xlsx & D:\EXCEL FORUM\Book2.xlsx
Range ( B1:B12 ) for Book2 and (a1:a18) for Book 1. Macro to run from DESTINATION WORKBOOK attached.
Hi
I need Macro that can copy ranges from 2 workbooks that are 'closed'. Their Address on PC D:\EXCEL FORUM\Book1.xlsx & D:\EXCEL FORUM\Book2.xlsx
Range ( B1:B12 ) for Book2 and (a1:a18) for Book 1. Macro to run from DESTINATION WORKBOOK attached.
You can use such code (I used a function originaly published on our national forum: https://www.excelforum.pl/viewtopic.php?t=12354 ):
Please Login or Register to view this content.
Best Regards,
Kaper
Simply
Please Login or Register to view this content.
Thanks Jindon, Just Excellent
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks