Add a row with formula

[merola]

I want a new row be created under the one I'mworking on,
with the same formula as the one above (same formula for all rows). So
everytime I enter text to the last row in the sheet, a new row with
formula will be created under it.

BTW I'm total newbie.. so please.. be gentle

 

[Dave Peterson]

Manually, you could just copy that last row and paste it below the last row.

Then wipe out the constants in that new row.
Select the row and Edit|Goto|Special|Constants|Ok|then hit the delete key on the
keyboard.

If you need a macro, David McRitchie as a version at:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

Look for: InsertRowsAndFillFormulas

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[merola]

Thank you...Its the makro I need, I'll try it out.

 

[Earl Kiosterud]

Merlola,

Another possibility: You may be able to use "Extend list formats and
formulas." It's in Tools - Options - Edit. YOu insert a row, then when you
fill in values, it automatically copies formulas down into that row. Also
copies formatting.