Re: copying formulas when inserting new rows

Tech-Archive recommends: Speed Up your PC by fixing your registry

Dave,
I checked my options and the box you reference is checked and yet when
I add a new row, the cells are not populated with any formulas.

On Sun, 07 Sep 2008 11:24:12 -0500, Dave Peterson
<petersod@xxxxxxxxxxxxxxxx> wrote:

You may want to try this:
Tools|Options|Edit Tab|check "extend data range formats and formulas"

Or you could use a macro...

David McRitchie shares some code:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Steve M wrote:

Is it possible to automatically copy formulas from other rows to new
rows when adding a new line in a spread***? I have cols A-AE of
which cols A-N are inputted and the others are calcualated values from
the data. How can I copy these formulas to the new cells when I add a
new row of data? Currently I have several 'dummy' rows that contain
the formulas that are used to input the data. Then I have to sort the
work*** to get the new rows inserted properly. I'd like to insert a
new row at the proper location, enter the data and have the formulas
copied to the new row. Any ideas?

.

Quantcast