Can inserted rows automatically include existing worksheet formula
I frequently need to insert rows to a worksheet which contains a formula
column. Is it possible to insert a row without having to manually copy down the formula from the previous row? Thank-you! |
Have a look at David McRitchie's site for a macro to insert rows and maintain
formulas. http://www.mvps.org/dmcritchie/excel/insrtrow.htm Gord Dibben Excel MVP On Tue, 20 Sep 2005 11:49:03 -0700, "tgdavis" wrote: I frequently need to insert rows to a worksheet which contains a formula column. Is it possible to insert a row without having to manually copy down the formula from the previous row? Thank-you! |
Perfect, thank you so much!
"Gord Dibben" wrote: Have a look at David McRitchie's site for a macro to insert rows and maintain formulas. http://www.mvps.org/dmcritchie/excel/insrtrow.htm Gord Dibben Excel MVP On Tue, 20 Sep 2005 11:49:03 -0700, "tgdavis" wrote: I frequently need to insert rows to a worksheet which contains a formula column. Is it possible to insert a row without having to manually copy down the formula from the previous row? Thank-you! |
All times are GMT +1. The time now is 10:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com