IF...THEN...insert row

[KJ]

Hi All

Is there a way of inserting a row if the value in the cell below is > the value in the cell?
ie if in A1 we have 5 and in A2 we have 7 I would need to insert a row below A1.

I would prefer not to do this using VB.

Many thanks

[dk]

Hi All

Is there a way of inserting a row if the value in the cell below is > the value in the cell?
ie if in A1 we have 5 and in A2 we have 7 I would need to insert a row below A1.

I would prefer not to do this using VB.

In a word, NO! A formula can't affect the Excel environment other than the cell it's in. This can only be done using VBA in the worksheet code module. If you want some sample code then please repost.

regards,
Dan

[Dave Hawley]

Hi KJ

If you would prefer a manual approach then try this.

In cell B1 put:

=IF(A1>A2,1,"")

Copy this down as far as needed. Now select all of Column B, push F5, Click "Special", check "Formulas" and uncheck all except "numbers" and Click Ok. Now go to Insert>Rows