Auto Fill formula when inserting a new line
"SRiddle" wrote in message
...
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 :-)
|