I have an Excel spreadsheet with a column of hyperlinks to all of the photos on my hard drive. In this spreadsheet I have a column for key tags for each photo. I want to be able to search the key tags and isolate each row that contains the key tags, hyperlinks and additional data in the spreadsheet. Here is an example of the key tags column
Events Baby Shower Lunch Feb 09 Kim's Baby Shower
Right now if I do the basic CRTL F search and I type in "Events Lunch" it will not find the above entry. Is there a Macro I can set up to continuously use that would put each matching entry in a new spreadsheet? Also I would like to be able to search for words that are not on the spreadsheet and produce a search with results, for example if I searched "Books Baby Shower" and no key tags in the entire spreadsheet had "Books" I would like to still see everything with "Baby" and "Shower" in the key tags column.
any tips or better ideas would be greatly appreciated,