Microsoft 365 and Office | Development | Other
Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have an excel sheet that has a dropdown list within which there are 10 tasks.
Each task has specific columns that need to be filled in, so on selection of a task from the drop down list the associated columns must show and the rest must be hidden. The same must happen each time a new task is selected from the drop down and the associated columns must show, and the others should be hidden.