Gordon Smith
asked on
Office supply form
Hello Experts!
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:
1. Vendors
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.
Thanks,
Smidy
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:
1. Vendors
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.
Thanks,
Smidy
ASKER
Yes it is a big project Reitzen.
I was just trying to get some basic code for the form and go from there. There will also be a form to add new vendors, materials and part numbers.
I was thinking about the WOW factor as well. I want to put a lot of time and effort into it so it will be easy for the the end user.
I was just trying to get some basic code for the form and go from there. There will also be a form to add new vendors, materials and part numbers.
I was thinking about the WOW factor as well. I want to put a lot of time and effort into it so it will be easy for the the end user.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Reitzen for taking an interest. I'll start with what you gave me and go from there.
I used Excel filters extensively. I had a table that contained all of our company's vendors with region codes included (some West Coast vendors were not available in the South, etc.). So, the primary drop-down listed available vendors based upon the selected property (apartment community). A vendor was selected and the PRODUCT table was filtered to a predefined range to display only the products/services offered by that client. Etcetera, etcetera.
The workbook was setup with a series of master tables (all vendors, all products for all vendors, all options for all products for all vendors, etc.).
Based upon the user's selection in the VENDOR drop-down, the PRODUCTS table was filtered. Based upon the user's selection in the PRODUCTS drop-down, the OPTIONS table was filtered.
It's actually very simple to build and create this kind of setup, it just takes a little planning and a fairly large file (lots of data to include all vendors, products, options, etc.)
You can get by without a form if you prefer to use a worksheet as the input form. It is much easier to go this route but you do lose some of the "wow" factor.
This is a rather large undertaking so if you need more assistance you would benefit from being a little more specific in your requests.
Good luck, and good coding!!