HI, I have recently worked with a chain of hotels, asking their customers how they rate each hotel. I have all the data and would like to present it in excel. I'd like to present it so that at the top of the spreadsheet is a drop down menu of all the hotel locations, and when clicked on, the data appears in the blank table below. I've done something like this before years ago but can't remember for the life of me. I'm fairly sure it has something to do with Vlookup.
Thanks in advance.