I’m trying to write a macro to copy results from one workbook to another rather than having to do it manually. I want to copy into my current worksheet (from STK.xlsm) the following cells:
Into Cell AB3 ='[STK.xlsm]Sheet1'!$AC$2
Into Cell AC3 ='[STK.xlsm]Sheet1'!$AC$16
Into Cell AD3 ='[STK.xlsm]Sheet1'!$AC$17
Into Cell AE3 ='[STK.xlsm]Sheet1'!$AD$8
Into Cell AF3 ='[STK.xlsm]Sheet1'!$AD$9
Into Cell AG3 ='[STK.xlsm]Sheet1'!$AD$10
Into Cell AH3 ='[STK.xlsm]Sheet1'!$AD$11
Into Cell AI3 ='[STK.xlsm]Sheet1'!$AC$5
Into Cell AJ3 ='[STK.xlsm]Sheet1'!$AC$3
Into Cell AK3 ='[STK.xlsm]Sheet1'!$AD$3

I want this to loop so the same cells in the next sheet (ie sheet2) are copied into the next row (AB4 etc) until the last sheet.