Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How am I able to del duplicate lines automatically | Excel Worksheet Functions | |||
Insert lines at each change in value | Excel Discussion (Misc queries) | |||
how can i insert a row every five lines in excel | Excel Discussion (Misc queries) | |||
insert lines | Excel Discussion (Misc queries) | |||
Macro insert lines | Excel Discussion (Misc queries) |