Hello everyone, i hope someone can help with this complicated issue, i have 5 Brand Name T-Shirts and they all have different colors and sizes for each brand, i would like when i select a brand i want it to show me which ever color and size i select i want it to show me the available amouth in that size. For example i select a brand name Gildan i then select the Color Red then i select the size small it show me i have 10 small T-shirts in that size available. FYI it has to be automated drop down menus
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
T-shirt brand color and size
0
Answers
0
You can make the drop-down menus using data validation and then use the SUMIFS() function to return the inventory amount.
Attached is a spreadsheet showing you how to do this.
To use data validation for the drop down menus, follow our tutorial here: Make a Data Validation Drop Down List Menu in a Cell in Excel