Wanting to run loop for multiple pages

[VeryConfused]

Hi everyone,

So I am very new to macros/VBA (as in started last week, new). I recorded a macro that I want to run on multiple pages. All the pages have the exact same layout and the names are the same, just with numeric changes (i.e. Data Template, Data Template (2)...). In order to do this, I am pretty sure I need a loop, but I don't know how to write a successful on. I would like if the code made each new page a name with the same pattern (i.e. Data Sheet, Data Sheet (2)...). I have included my very rough code (without a loop) in hopes that it offers detail I cannot give. I hope I explained this well. Thanks in advance for any help!

CustomerMacro.txt

[stnkynts]

This is one way to loop through each worksheet in a workbook. Is this what you were looking for?

Please Login or Register  to view this content.