JamieLee2k
New Member
- Joined
- May 9, 2004
- Messages
- 38
I will try to explain this the best way I can.
So there is a game called Animal Crossing and in the game you can catch Bugs and Fish, I am looking to make an excel sheet where I can choose from a drop down menu for a certain month so only the relavent fish or bugs show up so I know what is available for my specific month.
Lets narrow this down and give you an example of how it would look
Above are examples of how it will be layed out but what I need to do is add multiple months to each bug and then I can filter them to only display based on the month I select, a common Bluebottle is available from April-August and a Paper Kite Butterfly is available from Jan-Dec and a greate purple emperor from May-August, Since there are multiple months for each bug I want a drop down so say I select April it will only select bugs for april, I can do the drop down menu what I can't do is create multiple months and only select them
So there is a game called Animal Crossing and in the game you can catch Bugs and Fish, I am looking to make an excel sheet where I can choose from a drop down menu for a certain month so only the relavent fish or bugs show up so I know what is available for my specific month.
Lets narrow this down and give you an example of how it would look
Above are examples of how it will be layed out but what I need to do is add multiple months to each bug and then I can filter them to only display based on the month I select, a common Bluebottle is available from April-August and a Paper Kite Butterfly is available from Jan-Dec and a greate purple emperor from May-August, Since there are multiple months for each bug I want a drop down so say I select April it will only select bugs for april, I can do the drop down menu what I can't do is create multiple months and only select them
Attachments
Last edited: