Macro for inserting rows on a dataset

[sunilwadhwa]

Hi,

I'm new to VBA and need help in creating a macro for inserting rows on 2 conditions.

1st Condition - insert 3 rows between different "Divisions"
2nd Condition - insert 2 rows between the same "Division" but different "Sub Divisions"

Col A - Col B
Division - Sub Division
1 - 4
1 - 4
1 - 3
1 - 2
2 - 5
2 - 5
2 - 6
2 - 7
3 - 8
3 - 8
3 - 9
3 - 0

Hope someone can help me out. Any help would be truly appreciated

Thanks,
Sunil Wadhwa

[ajaykgarg]

loop for each row, store col A and B values for each row in two variables. compare values with values in last iteration. in case of change, insert rows as reqd.

hth
ajay

[JBeaucaire]

Please Login or Register  to view this content.

Try this out:

Please Login or Register  to view this content.