Hello
I'm trying to figure out a code that could insert a new row where the sequential numbering mismatching.
As you can see in the picture a row is missing for POS 2. I would like a code that could insert, in multiple places, during the sequence. For example, in some cases the sheet could be missing POS 3, 8, 15. And even the first POS1 (B2) could also be missing.
The amount of rows could be between 10 to 200
I have no example because I'm a newbie in this area.
I'm trying to figure out a code that could insert a new row where the sequential numbering mismatching.
As you can see in the picture a row is missing for POS 2. I would like a code that could insert, in multiple places, during the sequence. For example, in some cases the sheet could be missing POS 3, 8, 15. And even the first POS1 (B2) could also be missing.
The amount of rows could be between 10 to 200
I have no example because I'm a newbie in this area.