Search for a list of key words 2

[Swi]

What is the best way to search for a list of key words in several columns and if found move the matched records to a new spreadsheet? Thanks.

Swi

 

[SkipVought]

Hi,

I'd make a table of the strings to find.

Loop thru the table and use the Find method locate. When found, then cut and paste.

What code do you have so far?



Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[sxschech]

Although this was set up using a form in MS-Access with VBA for Access, the vba part may work for your purpose...

I have a text box on the form and the user enters the keyword, could even be a partial "SAN" would bring up any records that have San in it like San Francisco, San Jose, Santa Clara regardless of which field they reside in.

Global Search and Filter
thread702-1213703

 

[Swi]

That is exactly the method I was thinking as a result of recording a macro Skip. I just didn't know if there was a more efficient way. Thank you both for the tips.

Swi