Jul 02 2019 11:27 AM
Hi!
So I've recently started creating a video game "guide" on excel as a little side project. I wanted to make this one table that included all of the villager's gift opinions, but it was getting bigger and bigger with each villager added, and just all round seemed messy/hard to read. I thought about creating a drop down list that held all of the villager names and, when one was chosen, showed the different options for the villager, but it's been proving VERY difficult for me to wrap my head around.
Is it actually possible to achieve what I'm aiming for or should I just create different tables for each villager? I've attached a screenshot of the current table I'm working on, and what I wanted to achieve.
Jul 02 2019 11:44 AM
SolutionHi
I guess you want to create a searchable drop list. May be also dependent drop lists.
Here is a link to one of my tutorials on How to create a searchable drop list.
https://www.youtube.com/watch?v=8gqodEiDoJ8
here is a link to my tutorial on How to create Dependent Drop lists:
https://www.youtube.com/watch?v=0MuQfUJbycQ
Hope that helps
Nabil Mourad
Jul 02 2019 11:44 AM
SolutionHi
I guess you want to create a searchable drop list. May be also dependent drop lists.
Here is a link to one of my tutorials on How to create a searchable drop list.
https://www.youtube.com/watch?v=8gqodEiDoJ8
here is a link to my tutorial on How to create Dependent Drop lists:
https://www.youtube.com/watch?v=0MuQfUJbycQ
Hope that helps
Nabil Mourad