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.
|