Hello there! I want to be able to fill in cells B2:B26 with a certain value based on the selection of a dropdown (Combo Box) menu in cell B1. How can I achieve this? For example:
Dropdown menu in cell B1 has options:
- Low - Fills B2:B26 with value 0
- Medium - Fills B2:B26 with value 50
- High - Fills B2:B26 with value 100
Thanks in advance!