Glad to help.
--
Thanks,
Shane Devenshire


"KJ" wrote:

Shane Part one is awesome!! Exactly what I was looking for. Part Two I'm
going to live with. I don't VBA well enough to dabble like that. But thank
you very much!!

"ShaneDevenshire" wrote:

Hi KJ,

If you are using Excel 2003 select the data input area with titles and press
Ctrl+L, OK. If you are using Excel 2007 you can also press Ctrl+T, OK. You
are creating a list or table which will address your first issue. When you
complete the last entry on the new line press Tab.

To solve the second issue you may need to use VBA, here is a sample:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Set isect = Application.Intersect(Range("A2"), Target)
If Not isect Is Nothing Then
Range("A2:C2").Insert Shift:=xlDown
End If
Application.EnableEvents = True
End Sub

--
Cheers,
Shane Devenshire


"KJ" wrote:

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.