Inserting Rows with formulas automatically populated from the row above

[brose99]

I'm sure this is a simple fix, but I am trying to insert rows in an excel spreadsheet and I want the row I insert to automatically populate the same formula from the row above it.

For example:

In cell N6, I have =IF(C6="@",E6,0)
In cell N7, I have =IF(C7="@",E7,0)

Now if I insert an entire row between N6 and N7, I get a blank row with no formula.

N6 =IF(C6="@",E6,0)
N7 *blank*
N8 =IF(C8="@",E8,0)

I want the same formula to populate between the two cells when I insert a row without having to copy & paste or dragging it down or creating a table. I need to cut out a step.

N6 =IF(C6="@",E6,0)
N7 =IF(C7="@",E7,0)
N8 =IF(C8="@",E8,0)

Any help?

Thanks in advance!

 

[jasonb75]

without having to copy & paste or dragging it down or creating a table.

By eliminating those methods, you're only left with vba. There is no option to do it automatically.

 

[brose99]

I was afraid of that. Thanks for the info.