agarci1096
New Member
 Joined
 Nov 25, 2020
 Messages
 15
 Office Version

 365
 Platform

 Windows
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
0
0
0
0
1
1
1
1
However some groups will only have 2 or 3 rows and it needs to be 4
Like this:
Column H  Column I
2
2
3
3
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!
Like this:
Column H  Column I
0
0
0
0
1
1
1
1
However some groups will only have 2 or 3 rows and it needs to be 4
Like this:
Column H  Column I
2
2
3
3
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!