Search Table - Advanced Filter/Data Validation?

Hello,

I've attached a workbook that contains a data worksheet and search table worksheet. I'm attempting to develop a search table that allows me to filter data by 'Valve', 'Building' or 'Zone'.

Previously, users in this forum helped with a macro that allowed me to search by one criteria (currently titled "valve"). Can this can be expanded to include additional search criteria ("Building" and "Zone")?

I've set up a drop down list on the 'Search Table' worksheet for the additional criteria using Data Validation. On the 'Data' worksheet I've added the advanced filter criteria that links to the dropdown menus (see cells P2, T2, X2). From what I've read it seems these columns are required to develop the macro?

I've been trying to figure out how to write the macro but am getting nowhere!! Would it be possible to let me know if I'm going about this the right way and maybe suggest a macro or function that would allow the search features to work?


Thanks for your time!

Emily

Thanks to those who have looked over this post. I think it's going to be too complicated, so I'll probably just stick to simple filtering.

Cheers,
Emily