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

Jack


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

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