insert blank rows between base on count of rows, help???/

[Jhon Mustofa]

hii expert...

nice see you again,

i would need help you, to give me vba code about insert blank rows between base on count of rows, with criteria :

- if count of row = 1, result : nothing insert blank row
- if count of rows = 2, result : insert rows = 1
- if count of rows = 4, result : insert rows = 3
etc,.........

for further information,attaching my workbook...

thanks for appreciated....

regards..
john mustofa

[patel45]

Please Login or Register  to view this content.

[Jhon Mustofa]

it's not work.hii

Default layout (each row):
col.a col.b
2 Title1
1 Title2
2 Title3
3 Title4
1 Title5

After Macro: (inserted rows)
Title1

Title2
Title3

Title4


Title5

[patel45]

attach please a new sample with data and desired result