On Apr 20, 1:30*pm, GS wrote:
SRiddle used his keyboard to write :

I had someone show me this and I do not know how to set it up to work
like we saw. If I have a column of data and a formula in the column
next to when he inserted a new row at the end of the formulas, the new
row would contain a copy of the formula incremented from the row
above. Just like clicking on the box in the lower right hand corner of
a cell and dragging it down.
I am always inserting new lines and have to continually go out and
drag my formulas down to the new row.
There are now macros running, I am on XP and Excel 2007

Thanks
Scott

This will happen if you 'Insert Copied Cells' after copying a blank row
that contains the formulas you want to continue. If the cell refs used
in the formulas are row-relative then the copied row will increment
those refs automatically.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

You could have the formulas in row 1 (hide if desired) and have them
copied to the new row as desired by clicking a macro button or with a
worksheet_change event. Or, a macro can input the formulas or even do
the work and leave the values, if desired.