I want to create a menu on EXCEL to allow users to enter data into EXCEL in a friendly way
what I need help with is to create a drop down menu and radio button for some fields such as color, brand & sizes
Say if this is the excel file
Product ID | Name | Color | Size | Brand | Category | Sub category
Each product only have 1 brand so the brand is a drop down menu of brand A, brand B, brand C. Same with color - users can use white, red, blue, green, etc
However each product may many sizes so the size option should list all sizes (up to 200 variations) and allow user to select multiple sizes and after they select, the size should come in the table separate by a comma. Say 10A, 10D, 12A, 12B, 12 C, 14A, ....
Bra sizes are very complex! you have size 8-32 - the Cup size then goes from A - G - the combination is say 200 but I have already work out all the variation. I have list everything but need the menu to be created
Prefer someone you are experience and can start the job soon.