Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
new row insert on data entry
I am relatively new to excel.
Im developing a quoting tool using excel that consists of a number of drop down lists. What i want to do is when i select something from a drop down list, a new row will automatically be inserted underneath my selection. This feature will give me the option to continue adding entries without having to insert rows manually. Also, when a new row is inserted, i would like all the formulas associated with the previous row to be preserved in the new row. Any help is greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
new row insert on data entry
Depending on the version of excel, you may find that:
tools|options|Edit tab|Check Extend data range formats and formulas Or you could use a macro to insert rows. David McRitchie has one: http://www.mvps.org/dmcritchie/excel/insrtrow.htm look for: InsertRowsAndFillFormulas If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm cjupiter wrote: I am relatively new to excel. Im developing a quoting tool using excel that consists of a number of drop down lists. What i want to do is when i select something from a drop down list, a new row will automatically be inserted underneath my selection. This feature will give me the option to continue adding entries without having to insert rows manually. Also, when a new row is inserted, i would like all the formulas associated with the previous row to be preserved in the new row. Any help is greatly appreciated. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Get External Data - Insert Rows | Excel Discussion (Misc queries) | |||
insert data into chart | Charts and Charting in Excel | |||
insert data from one excel file into another | Excel Discussion (Misc queries) |