software

I want to be able to let people insert a new row below an existing row, and
in doing so the formula from above also gets copied but not the data in other
cells, either by using a macro or a command button.

Ideally I would just like them to be able to insert a row and the formula
gets copied as well.David McRitchie has a nice macro that asks how many rows should be inserted and
even copies the formulas down to those new rows.

www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas

Belgarth wrote:
gt;
gt; I want to be able to let people insert a new row below an existing row, and
gt; in doing so the formula from above also gets copied but not the data in other
gt; cells, either by using a macro or a command button.
gt;
gt; Ideally I would just like them to be able to insert a row and the formula
gt; gets copied as well.

--

Dave Peterson