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
0
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.
0
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
0

Similar discussions

Facebook Messenger - Suggested Friends
jadess_0462 -
Akajackal -

2 responses
Anyone's dm order all weird ?
Tillyleon111 -
toogleeful -

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