Hi All,
What I need to do is copy the data from cells A2 & B2 in the worksheet “BOM” from all the workbooks within a given folder - Q:\AX SYSTEM\Excel to AX via Schedule\count BOMs\ & paste it into a list in the worksheet “Sheet1” of workbook “Count Cores”.
Pasted data will start in cells A2 & B2 then continue down through A3 & B3, A4 & B4 etc until all workbooks from the folder have been copied & pasted.

Other cells within “Sheet1” are populated & will run calculations based on this list but hopefully I can actually do that bit 😉

Thanks in advance for any help offered.

Lee