How to insert a row in excel based on values in the cell

March 21, 2013 at 22:33:48
Specs: Windows 7
I would to insert a row in excel only if by comparing two valves in seperate sheet and if the value matches copy the entire row paste it by inserting a new row below it. can this be done easily with formula or should we have to go macro. please help me with this

See More: How to insert a row in excel based on values in the cell

Report •

#1
March 22, 2013 at 03:55:35
A formula can not insert rows, so you will need a macro.

We will need more details before any help can be offered. What values are be compared, which sheets, etc.

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


Report •
Related Solutions


Ask Question