How do I loop through worksheets

[pablowilks]

I want to loop through 10 worksheets in my workbook (sheet1, sheet2...sheet10) and copy the data from A1 in each sheet and paste into column A in sheets("data"). Sheets("data") is part of the same workbook.

Many thanks in advance

[Trebor76]

Hi pablowilks,

Try this:

Please Login or Register  to view this content.

Regards,

Robert

[pablowilks]

this is great thankyou Robert

[Trebor76]

Thanks for the feedback and you're welcome