Automatically insert lines?
OK brainstormers.
I'll simplify what I'm trying... Picture a quote sheet created. The line
item portion of the quote would lie from A1 to B3. (Quantity, Item, Price)
It would total in row C (C3).
I enter my info on row A and hit enter I automatically go to row B. Is there
a function I'm missing where after I enter the last item on row B (Price)
that I would automatically get another row inserted, as if I had more items
to quote?
I've seen a function like this in databases, but I need to keep this
function a part of Excel.
Part Two. Again I've seen this in databases but need to keep in Excel. To
keep track of my quotes is there a way so that the first row is blank. As I
enter my customer name and total price that it would automatically move it to
row B and again row A would be blank?
I'm not an experience code writer so if VBA is my only option just tell me
I'm SOL!
Thanks to one and all.
|