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

A macro solution from David McRitchie can be found here...............

http://www.mvps.org/dmcritchie/excel/insrtrow.htm


Gord Dibben MS Excel MVP

On Wed, 20 Apr 2011 06:08:16 -0700 (PDT), SRiddle <(E-Mail Removed)> wrote:

>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

"SRiddle" <(E-Mail Removed)> wrote in message
news:54730535-7af1-4462-aded-(E-Mail Removed)...
>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
>


I seem to recall that being an option when setting up a "list" in
xl2003. Anyone know if that functionality carried over into 2007 when
they changed "lists" to "tables" ??

Although, as I recall, that did not occur when inserting a new row into
the table, only when extending the list by entering new data into the
empty row below the list.

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)

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 at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

On Apr 20, 1:30*pm, GS <g...@somewhere.net> 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.