VBA insert row if conditions are met

[agarci1096]

Hi, I have a data set that has rows numbered groups of 4 rows counting up from 0 to 100. It will then start over at 0 and count up to 100 again, and repeat this several thousand times.
Like this:
Column H ---- Column I
1
2 0
3 0
4 0
5 0
6 1
7 1
8 1
9 1

However some groups will only have 2 or 3 rows and it needs to be 4
Like this:
Column H ---- Column I
10
11 2
12 2
13 3
14 3
15 3

I'm fairly new at macros and am pretty lost on this whole thing. I need a VBA that will insert a row with the number of the group if there are less than 4 rows to a group. Any help on where to start with this would be greatly appreciated!

 

[Fluff]

Duplicate I need a VBA to count groups of 4 rows and insert a row if there are less than 4 rows to the group

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).