Looping Issue

Hi all,

I'm currently run into some issues with my VBA loop.
I had it working for a specific number of iterations (for x = 1 to 104), but am still learning it all so wanted to try and get it to loop until the end of the data, so I can use it more flexibly in future.
I changed it all, thought I had it all working, went to run the full macro and it just stopped after running through once.
X = X+2 and Y = Y+3 are there because I need it to check every second/third column, as we're working with groups of columns.
Any ideas?

Thanks!

Please Login or Register  to view this content.

Have thrown together the sample doc below.

If you run LooperFullGDP on the GDP sheet, you will see what the macro is meant to do.
If you run LooperFullRest on the FORUM sheet, it should do almost the exact same thing, but the Format Rest will also happen after, which will change the first 27 groups, and leave the remaining 77 (These would usually be deleted but for the sake of display, I have left them in for now) as in the other sheet.
I have only attempted to change the format rest looping at this point, hence why they're both in there.

Hopefully this makes more sense now and you can see the issue I was having.

Thanks

I don't doubt that there's an easier way to do it, I'm still very new with VBA, I've only been working with it for about a week, so I'm pretty happy with the progress I've made up to this point.
For now, I'm trying to make small changes, so I can at least get it to work, before I go back and try and make it easier. Baby steps!

Each of the individual macros works, and when looped using the ForTo method, is no problem either, so I'm just trying to bridge that gap here.
I'm open to a complete overhaul, but the looping is the biggest concern for now as I have plenty of other areas I'd like to use it in, but don't understand it at the moment.
I hope where I'm coming from, sorry to be a pain!

Can't really avoid merging the cells here, I don't think. I didn't design the workbook, so trying to keep it as similar in appearance as I can.
As for your questions, the numbers aren't continuous, which is a bit of a nightmare.
All the dates currently are just entered individually, but end goal is to populate about 12 sheets from one central page, when adding a new employee. Although even then, they will be added individually, not looked up from another document or a database.

As you say, I'd ideally like to be able to edit one group and then copy the formatting across. But I've been working on one thing at a time which is why it's currently structured in this way.

As I said before, I'm open to making it more streamlined, but that doesn't take away from the fact I still want to understand why the do while loop isn't working, and how I can use it moving forward. More than anything I'm just trying to learn, and at the moment, this happens to be the current problem I'm trying to solve alongside that process.

I suppose I hadn't really thought about it in depth, but the idea was that the changes to the headers would be made before the macro was run, so that it wouldn't have to run 104 groups each time, because the other info that will be going in will have no more than about 20 groups.
Considering it takes time for the macro to run through 104 iterations, even though it's a lot quicker than manually doing it, seems a bit pointless considering we could run it 20 times, or even 10.

So for example, if we take the FORUM sheet for example, it doesn't need to run through 104 iterations, as we only need the 27 TSOP's. So it would be ideal if we could get it to look across to where it first contains GDP, clear contents and formatting from there onward, and run the formatting for what hasn't been deleted.
The GDP sheet is the base that I have to work on, for all of the different sheets to be created, of which TSOP's will be the biggest, hence the mess.