I have around 20 sheets with data that I need to be able to hide and unhide rows based upon what data is shown in a validation list on the first sheet. I have attached an example file to hopefully clarify things. Basically I am trying to filter for location and I only want to be able to see the rows on every sheet that correspond with the information found in my validation list. Each sheet has varying amonts of columns and rows as well. Thank you for your help I really appreciate it!
Bookmarks