View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KJ KJ is offline
external usenet poster
 
Posts: 43
Default 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.