Good Morning,
I am trying to create a sheet whereby a table returns only those values that are selected from either one of two drop down lists.
The first drop down list has categories, for example: Onboarding, Facility Management, Admin Tools.
The second drop down list has specific areas of interest: Deal Closure, Compliance, Fees etc.
I want to make it so that a user can select one option from either or both of these drop down lists which then populates a table below that with information.
This information is stored on another sheet as a 'database'.
I have tried using hide and unhide row macros but these don't seem to be flexible enough.
How can I make it so the table populates based on the selections (almost like an IF function I would guess)?
Any help with this is greatly appreciated.
Regards,
S
I am trying to create a sheet whereby a table returns only those values that are selected from either one of two drop down lists.
The first drop down list has categories, for example: Onboarding, Facility Management, Admin Tools.
The second drop down list has specific areas of interest: Deal Closure, Compliance, Fees etc.
I want to make it so that a user can select one option from either or both of these drop down lists which then populates a table below that with information.
This information is stored on another sheet as a 'database'.
I have tried using hide and unhide row macros but these don't seem to be flexible enough.
How can I make it so the table populates based on the selections (almost like an IF function I would guess)?
Any help with this is greatly appreciated.
Regards,
S
