On the attached spreadsheet, I am trying to filter the "Database" worksheet by using criteria held in the "Summary" worksheet cell B1. The criteria range is "Database!B:B".
I want the results to return into the "Summary" worksheet. I have populated the results I'm trying achieve and highlighted them yellow.
I know I can simply use a column filter but I need to have the results return into a separate worksheet.
Hopefully all that makes sense.
Thanks in advance.
Bookmarks