IF THEN to insert a blank row

July 24, 2011 at 11:03:52
Specs: Windows Vista
I'm trying to create an IF THEN formula somewhat like this, if C2 does not = C3 then insert one (or two or three) rows then add C plus other C's in that range then show sum then insert one (or two or three) rows and repeat equation...MS Office, Excel 2007 & 2010.
Any ideas? Thanks.

See More: IF THEN to insert a blank row

Report •

#1
July 24, 2011 at 13:01:03
You cannot use an Excel formula to insert rows.

Excel formulas cannot perform "actions", they can only produce values (or errors) based on the result when the formula is evaluated.

If you want to insert rows based on the value in a cell, then you will need to use VBA (i.e. a macro).

That said, I don't know what you mean by "if C2 does not = C3 then insert one (or two or three) rows".

You stated one condition (C2<>C3) yet you've asked for 3 different actions (insert one (or two or three) rows). How would the macro know whether to insert 1 or 2 or 3 rows?

You will need to clarify what you are trying to do before we can offer any more assistance.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question