Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a row below
I want to be able to let people insert a new row below an existing row, and
in doing so the formula from above also gets copied but not the data in other cells, either by using a macro or a command button. Ideally I would just like them to be able to insert a row and the formula gets copied as well. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting a row below
David McRitchie has a nice macro that asks how many rows should be inserted and
even copies the formulas down to those new rows. http://www.mvps.org/dmcritchie/excel/insrtrow.htm look for: InsertRowsAndFillFormulas Belgarth wrote: I want to be able to let people insert a new row below an existing row, and in doing so the formula from above also gets copied but not the data in other cells, either by using a macro or a command button. Ideally I would just like them to be able to insert a row and the formula gets copied as well. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Objects | Excel Discussion (Misc queries) | |||
help with inserting a cell value into a named formula | Excel Discussion (Misc queries) | |||
inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
whats the keyboard short cut for inserting a row in Excel | New Users to Excel | |||
Inserting Footer - Ajit | Excel Discussion (Misc queries) |