Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill formula when inserting a new line
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill formula when inserting a new line
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 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 :-) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill formula when inserting a new line
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Fill formula when inserting a new line
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible to auto-fill in gaps between numbers on straight line bas | Excel Worksheet Functions | |||
Auto fill formulae when inserting rows | Excel Discussion (Misc queries) | |||
Inserting line breaks in text formula | Excel Discussion (Misc queries) | |||
auto update formula when inserting additional columns | Excel Worksheet Functions | |||
Auto formula fill | Excel Discussion (Misc queries) |