Loops and IFs

[nyum]

Hi,

I'm wondering if someone can help me with a simple macro.

I want a Macro to look in Cell C1, if it is NOT blank, then Select Cells A2 to B2 and insert cells and shift everything down. Then move down to C2. If C2 is Not blank, Select Cells A3 to B3 and insert cells and shift everything down then move down to C3. If C3 is blank then just move down to C4.

And keep looping until the end of the column.

Any assistance will be greatly appreciated.

[timbo1957]

Surely this won't work?

If c1 >0 Then insert two rows this will move c2 to c3 and c3 to c4.

Then you want to check c2 which you have moved to c3 by your previous action.

[nyum]

No I actually have Data in Columns A and B.

for example
test1 test1 comment1
test2 test2 comment1
test3 test3 comment1
test4 test4
test5 test5 comment2

so starting on the first, if c1 isn't empty...
it becomes
test1 test1 comment1
_________ comment1
test2 test2 comment1
test3 test3
test4 test4 comment2
test5 test5

And you loop it until say test2 and comment2 are aligned and so forth for the rest of the data. Inserting a row will push the comment lines down and I only need the data in A&B to move down.