AllisonCorey
New Member
- Joined
- Apr 4, 2017
- Messages
- 4
Hi everyone,
My boss wants me to make an order form in Excel. I have the drop-down menus all in place, but one of the menus has a selection that must default another menu to a specific selection.
E.G: We offer wood furniture and one of the stain colours is only available in cedar, so if a customer chooses the Caramel stain, the wood menu must default to cedar. Is there a way to do this, and if so, what formula or rule would I use?
Thank you in advance!
My boss wants me to make an order form in Excel. I have the drop-down menus all in place, but one of the menus has a selection that must default another menu to a specific selection.
E.G: We offer wood furniture and one of the stain colours is only available in cedar, so if a customer chooses the Caramel stain, the wood menu must default to cedar. Is there a way to do this, and if so, what formula or rule would I use?
Thank you in advance!