Do While Nested Loops

Hello,

I'm struggling with a nested loop and could use some help/guidance on. I have a sheet with a random amount of data (see attached). My goal is to insert a row and concatenate some text based on the cell below its' value. The below code kind of does this portion, but it stops working when it gets to numbers for some reason (i.e. for some reason, when I run the code it is not determining the difference between "1" or "2", but it is recognizing all the other changes in values. This is basically part 2 of the nest.

Part 1 of the nested loop requires me to ignore everything from "StartHeader" through "N" so any values in between will just pass a row count + 1. Once the macro reaches "N" it will know to automatically insert a row below "N" and concatenate "Page " and the value of the Cell immediately below this new line and then move on to the next row and check it's value against the previous row.

Once it detects a change, it again adds a new line and concatenates "Page" and the value of the cell immediately below.

This continues until we reach "StartHeader" where we basically don't do anything until we get back to "N".

Please Login or Register  to view this content.

This was absolutely perfect! Thank you so much.

Thanks to everyone who responded. Some good code in all of them that I should be able to utilize down the road!