i have one common worksheet ("planning") from different workbooks (data1, data2, data3,...,etc), which i want to copy to target workbook to ("Master.xlsm"). the code which i have written, is only copy the sheet from first workbook (data1), and then after i get runtime error " 9: subscript out of range". please help me further.
Please Login or Register to view this content.
Bookmarks