VBA loop through sheets, copy cells to master sheet

[wannabeexcelguy]

Hey gurus,

VBA beginner here. Thanks for taking the time to read my post (if you read it). Below is what I am trying to achieve - example file is attached.

• Loop through sheets in the same workbook (starting at sheet5 through to the last sheet in the workbook, the amount of sheets will vary)

• Copy cell B1 AND the last cell in column S in each sheet of loop

• Paste B1 from each sheet in the next blank cell of column U in sheet2 (the first paste needs to start after the last used cell column U, which is U947 in the example workbook but will vary)

• Paste the last cell in column S from each sheet in the next blank cell in column V of sheet2 (the first paste needs to start after the last used cell column V, which is V947 workbook in the example but will vary)

Is there VBA code which could do this? I appreciate any responses!

[bakerman2]

Please Login or Register  to view this content.

[wannabeexcelguy]

Wow, that's some compact and fast code - very nice. Works perfectly with a copy paste! Thanks!

[bakerman2]

You're welcome