i want looping all workbook book1,book2,book3,book4 and workbook master.xlsm (total 5 workbook)
in 5 workbook contain sheets : sheet1,sheet2,sheet3 sheet4
i want
step 1...book1.sheet1.range(M & lastrow) copy to master.xlsm sheet1 range(K10)
book1.sheet2.range(M & lastrow) copy to master.xlsm sheet2 range(K10)
until book1.sheet4.range(M & lastrow) copy to master.xlsm sheet4 range(K10)
step 2 book2.sheet1.range(M & lastrow) copy to master.xlsm sheet1 range(K11)
book2.sheet2.range(M & lastrow) copy to master.xlsm sheet2 range(K11)
..more again looping book1.sheet4 and book4 from sheet1 to sheet4 to Master.xlsm
dst...
until step 4 please help me
in 5 workbook contain sheets : sheet1,sheet2,sheet3 sheet4
i want
step 1...book1.sheet1.range(M & lastrow) copy to master.xlsm sheet1 range(K10)
book1.sheet2.range(M & lastrow) copy to master.xlsm sheet2 range(K10)
until book1.sheet4.range(M & lastrow) copy to master.xlsm sheet4 range(K10)
step 2 book2.sheet1.range(M & lastrow) copy to master.xlsm sheet1 range(K11)
book2.sheet2.range(M & lastrow) copy to master.xlsm sheet2 range(K11)
..more again looping book1.sheet4 and book4 from sheet1 to sheet4 to Master.xlsm
dst...
until step 4 please help me
Last edited: