Previous Topic Next Topic

Conditional data display depending on a dropdown list

Closed
Paskie_be - Jan 6, 2016 at 05:44 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 6, 2016 at 12:05 PM
Hello,

I would like to creat a form which would display certain data dependent on what was chosen in a dropdown list.
For example, if my dropdown list features a number of International Organisations (NATO, African Union, United Nations, European UNion, ...) I would like Excel to display the countries that are members of that one particular International Organisation I have chosen from the dropdown list.

Thanks,

Pascal

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jan 6, 2016 at 11:21 AM
You said Form. Do you really mean form or you mean sheet. In either case you would have to have this information saved where country and organization to which they belong to is stored to be then later use for the dropdowns
Paskie_be
Jan 6, 2016 at 11:36 AM
Yes, sorry. I did mean sheet that will have a header and a footer to make it look nice when printed. Now the question is how do I go about it. My table with IOs and relevant countries is ready in a file. All there's left is to find the right instructions to get the ball rolling.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766 > Paskie_be
Jan 6, 2016 at 12:05 PM
see if this helps
https://ccm.net/forum/affich-269392-dropdown-lists-in-excel-2007

Similar discussions

Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses
Snapchat block list
Jasonve -
dwebb -

1 response
Facebook Messenger - Suggested Friends
jadess_0462 -
Akajackal -

2 responses
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
A random chat ALWAYS top of my facebook messages on desktop
glock339 -
glock339 -

11 responses