Autofill Formulas on New Row Insert

[mcmuney]

When you insert a new row, how can you have the row automatically populate with the formulas from the above row? (instead of having to copy down the formulas)

[stanleydgromjr]

mcmuney,

You would have to highlite the entire row for this to work:
Worksheet Insert Row Event by Tom Urtis
http://www.mrexcel.com/archive2/72100/83615.htm

Can we see your workbook with the formulae?

To attach your workbook click on the New Post button, then scroll down and click on the Manage Attachments button.

[royUK]

Which version of Excel are you using?

[mcmuney]

I'm using Excel 2007. See attached workbook. For example, when you highlight row5 and insert a new row, I'd like it to populate the new row with the formulas as if I dragged it down from the row above.

[stanleydgromjr]

mcmuney,

Detach/open workbook mcmuney - EF752233 - SDG15.xlsm.

Highlite a row and insert a new row. The formulae from the above row will be copied to the newly inserted row.