I need to be able to search my company's library by keyword and/ or other filters (sample file attached below). The library contents in a master list defined by title, subject, category, bookcase#, and Shelf #. I researched a way to research by keyword by typing a text and all titles that contain the text is displayed.
I need to accomplish the complete researching capabilities as follows (Formula or VBA):
[*=1]I need to be able to couple the above with applying any other filters and pull all titles that meet all criteria (sample file attached).
[*=1]I need to be able to use the filters only regardless to the keyword and display all titles that meet all criteria
[INDENT]
forum.ozgrid.com/index.php?attachment/49269/[/INDENT]