Office supply form
Posted on 2012-03-13
I haven't asked any questions in a long while since I usually find an answer here. I'm not sure if this can be done but. . .
I have been asked to create an Excel workbook that users would be able to order work supply materials.
As they select items in the order form, it would fill a sheet for all the materials that each person orders so there would be one order log. This would then be emailed to the admin responsible for placing the order.
I would like to start with a drop down list of:
User would make a selection from a list of several.
Based upon that selection, it would move to the list of materials available from that vendor.
It would automatically move on to the next selection box . . . (selection in properties right?)
2. Material Description
Gloves, Labels, Stickers, Pens . . .
again, based upon what that selected vendor supplies
3. Color or Size
Red, Black Blue, Small, Med, Large . . .
4. Part number
5. Quantity needed
I'm sure Access would handle this better by the company licenses out each one. Everyone has Excel available to them.
I'm up to the challenge. It's just been a long time since I've created and coded a form with multiple drop down lists so I need some serious help.