MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Building a key word fuction into my database

Posted by JackJJ on January 21, 2000 9:55 AM

I have built a large database that I would like to be able to search by "Keyword". I have checked the Excel help with no luck. I would like to be able to input a keyword and have all matching data comes up.

If anyone knows how to set this keyword seacch up, please let me know.

Thanks in advance


Posted by Celia on January 21, 2000 4:37 PM

Can Excel's filter tool provide what you need ?
If not, a simple loop macro should do the trick.