Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

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

Re: Building a key word fuction into my database

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.