Thread: Conditional Drop Down Menu - multiple variables

I work for a small fashion company, and I want to (for fun as well as to help improve the company) improve our inventory sheet on excel. The current sheet is not very organized. I need help on creating drop down menus that are all linked together.

So there are styles, size, color, fabric, and quantity.

For example, style 1234 can be in size XS to XL, the colors could be black, white, etc, and the fabric could be cotton, or wool etc.

I would like it to be that on the main page (the only page my boss would use) she woulld open the first drop down menu and select the desired style, then the next drop down menu lists the sizes, then the next does the color, and the next is the fabric, and after you do that the quantity appears in a specified cell.

This way my boss can easily see what quantity she has of a specific garment when a boutique calls and asks how many of #### in _____ she has, and she doesn’t have to run and go check the warehouse.

As the fashion industry constantly is adapting to the people needs I would like it to be easy to add new colors and styles without having to redo the entire excel sheet.

An added bonus would be to have the ability to (from the same page) put in a request to add more of that style or remove and in doing so update the inventory.


If somebody could tell me how I would start this that would be wonderful, then I could take it from there. Thanks a bunch.

Hello,

does that mean that ALL styles are available in ALL fabrics and ALL sizes and ALL colours?

It might be easier to have the inventory as a contiguous Excel list with the columns

Style _|_ Fabric _|_ size _|_ colour _|_ stock level

Then you can build a pivot table. With Excel 2010 you can use slicers to make it very easy for the user to drill down to a particular item. If you select a style with a slicer, the Fabrics slicer will automatically only show the fabrics for that style, etc.

Post some sample data in a workbook if you need help setting up such a pivot table.

cheers,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST