Microsoft 365 and Office | Development | Other
Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
Using a dropdown list, how to hide non-related columns and show related columns
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 32%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWB%3C/text%3E%3C/svg%3E)
Wesley Butler
0
Reputation points
A selection is made in a dropdown list, the columns that are related to the option selected must be shown so the columns can be populated. The columns not related must be hidden. When the next item is selected from the drop down, the related columns must be shown and the non related columns hidden - so on and so forth.
Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Sign in to answer