keyword filtering

Hello Genki,

Welcome to the Forum!

Your name Genki in Japanese means to be healthy and it good spirits. I hope that your are. If you have a workbook with the data, please post it. It will amke it easier and faster to answer your question.

Sincerely,
Leith Ross

Originally Posted by Leith Ross

Hello Genki,

Welcome to the Forum!

Your name Genki in Japanese means to be healthy and it good spirits. I hope that your are. If you have a workbook with the data, please post it. It will amke it easier and faster to answer your question.

Sincerely,
Leith Ross

I'm glad u know the meaning of my nick
here the sample of the file, usually it would be longer, and he said it would be different each week (the lenght) as you can see, there a lot keyword everywhere
like oracle, not only oracle but there oracle project, oracle bundled, so when he input oracle all the row that have that word showed..
any help/sample? I'm really2 thankful..

Hello Genki,

Will these keyword be under a particular column heading or do you want to search all columns for the keyword?

Sincerely,
Leith Ross

or if the filter not possible/too hard, how about change it to copy paste to a new worksheet?

so copy the row that have that keyword into new worksheet, and it could be multiple keyword, is that possible?

Hello Genki,

It would be easier to place the filtered data on a separate worksheet. When a match is made will the entire row be copied to the new sheet or only certain columns?

Sincerely,
Lieth Ross

Hello Genki,

I have one other question. Where will the words be located that the filter will use?

Sincerely,
Leith Ross

Originally Posted by Leith Ross

Hello Genki,

I have one other question. Where will the words be located that the filter will use?

Sincerely,
Leith Ross

basically on input box, but if can't it's ok using static keyword (put inside the macro) mostly only around 6 keyword

Hello Genki,

It took some time to put this together. Here is what the macro does...

1) You call it by using the keys Ctrl+K.
2) An input box will ask you for the keywords you want to look for. The search ignores case, but spaces are not. Separate multiple search items with a comma.
3) Wildcard characters * and ? can be included when searching.
4) The keywords are copied to the Results worksheet and each cell that a keyword was found in is highlighted in yellow.

Here is the macro code for those who are interested...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

OMG thanks so much Leith!!!
how can I thank u???

thank you very much leith!! I am a newbie to excel programming and eager to learn,..You inspire someone like me. Thank you for your unconditional sharing..