How do I repeat a macro for each page without having to copy the macro for every page

[dmccue]

I have a spreadsheet that is 40 pages (can't attach) that spans across a 14day period with 1 sheet for each day
The macro reads another sheet and fills in my daily sheet

How do I write this so I can condense the actions rather than having to copy it for each day.

This is what I have written for the 1st 2 days and it works ok but I would like to condense it
GT MON WK1 is where the macro is reading from for 1st sheet
GT TUE WK1 is the next day etc etc

Any ideas?

Please Login or Register  to view this content.

[Pepe Le Mokko]

Tags added

[dmccue]

Now updated