Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
VBA macro to use a drop down list, and by the selection all related columns must show and the rest be hidden.
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.
Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Processes in Microsoft 365 for setting up Office apps, redeeming product keys, and activating licenses.
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data