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.

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