Excel filtering with drop down menus
I have agreed to help in creating a new inventory of multiple things across our site. This is primarily to be used by other members of staff and they have always used a spreadsheet to do this so I am trying to keep with what they know. However, I can see that the amount of information that is going to be recorded is going to produce lots of information and I am hoping that I can make this easier to read using filters.
What I am trying to do is create a pull down menu which will privde a list of areas that the inventory covers which will then filter the rest of the infomation shown. I could have sworn I have used something similar before but when I have tried it myself using the filters it the dropdown option takes me to the filter options. Basically what I want is something similar to:
Area Location(dropdown list allowing users to select Area A, Area B...)
Area A (Data which matches the Area Location selection)
Is this possible, have I made all this up or am I just making more work for myself?