Previous Topic Next Topic

Conditional data display depending on a dropdown list

Closed
Paskie_be - 6 Jan 2016 à 05:44
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 6 Jan 2016 à 12:05
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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
6 Jan 2016 à 11:21
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
6 Jan 2016 à 11:36
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 28 January 2010 Status Contributor Last seen 5 May 2022 766 > Paskie_be
6 Jan 2016 à 12:05
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
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses