L
Learner101b
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.
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.