Forum Discussion
vba code assist to hide/show based on drop-down list selections
Subodh_Tiwari_sktneer uploaded to original message.
You responded to @Subodh_Tiwari_sktneer's request with a full upload of the lists you're working with. But you didn't respond to his equally important request, that you "then describe what exactly you are trying to achieve."
It strikes me that it's possible that the new Dynamic Array functions might be able to achieve your task; they can do some pretty remarkable things with drop-down lists.....but we do need to know more precisely what it is that you're aiming to achieve.
mathetes and @Subodh_Tiwari_sktneer I am trying to create a simple dashboard that show only the rows of data that are being selected based on the selections in 2 drop-downs as opposed to showing the full table of data.
Also, I am not using Office 365 so I do not have XLOOKUP and the newer formula capabilities. I greatly appreciate your assistance.
Without any VBA or macro, I did the attached using the Dynamic Array functions SORT, UNIQUE, and FILTER, and simple Data Validation (again no VBA or macro) on the two selection cells. See if it does what you want. If not, please clarify what it is.
After selecting the Role and Region desired, there's one formula that displays the selected rows from the data. That formula is: =FILTER(Data!C5:H474,(Role=FilterDash!D4)*(Location1=FilterDash!D6))