Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Order form design
I am a first time user of this discussion group, semi-technical and use Excel
2003. I want to create an order form on worksheet 1 that would also create a specific vendor purchase order on a separate worksheet. In other words, I want worksheet 1 to be an alphabetical list of many items that would be purchased from 10 different vendors. When a customer puts a number in the 'quantity' column, I want that line including item number, description, etc. to move to another worksheet that is specific to the vendor the item is ordered from. I have 2 requirements that are giving me problems in developing a design. (1) I prefer to make additions/deletions from the main list on worksheet 1 to make updating easy rather than having to go to the vendor purchase order worksheet and make changes there as well. (2) Some vendors will have 30 items on the main list (which will be multiple pages), but most customers will only order a couple of them at a time. I would like to keep the final vendor purchase order to a single page so I prefer to not have all 30 items listed on the purchase order with only a couple of the items having quantities in the 'order' column. I would really like to 'push' the information from the order form on worksheet 1 to the vendor purchase orders when there is a quantity in the order column, but I do not think Excel can do this. I am pretty good with Excel basics, but have never filtered lists, used complex conditional formulas or functions, used pivot tables, etc. But I am willing to learn. Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to design a form | New Users to Excel | |||
Design a form | New Users to Excel | |||
Design complicated form | New Users to Excel | |||
Worksheet form design | Excel Discussion (Misc queries) | |||
design form? | New Users to Excel |