Patrick O'Dea
asked on
Display Excel details based on user input
Hi,
This is a simplified version of a post I made a couple of hours ago.
If this is contrary to etiquette then please advise!
It is best explained by looking at the attached.
When the user enters one of the 3 yellow cells (i.e. chooses a country) then ... this countries details should be displayed in full in the green section. Note that the source of all the end data is the table on the far left.
So, entering one of the yellow cell generates a "drill down" in the green area.
How can I achieve this?
EEMan2.xlsx
This is a simplified version of a post I made a couple of hours ago.
If this is contrary to etiquette then please advise!
It is best explained by looking at the attached.
When the user enters one of the 3 yellow cells (i.e. chooses a country) then ... this countries details should be displayed in full in the green section. Note that the source of all the end data is the table on the far left.
So, entering one of the yellow cell generates a "drill down" in the green area.
How can I achieve this?
EEMan2.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thank you. Glad I could help!
ASKER
Thanks for a superb answer.
In particular, it is great because it is so relatively clean and simple.
(I need to convert this logic into my real world scenario but that's a different project!)
Thanks again!