Hi, this is my first post here. I've searched through the forums and cannot find a previous post that answers my question. I'm just starting to learn how to code in Excel VBA. Can anyone help with how I can write a subroutine that will take a batch of every three worksheets and write them out to a new workbook? I have a master workbook with a group of three worksheets for each person (60 worksheets in all plus a couple of summary sheets) and would like to split each person's three worksheets plus a copy of the one universal summary sheet out to a new workbook every week.
I've seen code that creates a new workbook for every worksheet but not every three. I tried writing a For each...Next loop with a counter that skips to every third (at least to get me started) but I do not know the syntax well enough to even do that.
I'll continue reading my VBA books and if I get an answer I'll come back and post it here but if anyone could help in the meantime I'd be very grateful.
Thanks.
Seagreen
I've seen code that creates a new workbook for every worksheet but not every three. I tried writing a For each...Next loop with a counter that skips to every third (at least to get me started) but I do not know the syntax well enough to even do that.
I'll continue reading my VBA books and if I get an answer I'll come back and post it here but if anyone could help in the meantime I'd be very grateful.
Thanks.
Seagreen