keyword filtering

**genki** · 11-14-2008, 03:44 PM

Hi all,
I'm quite newbie for VBA for excel, my friend asked me a favor to filter the data on his excel, so when he enter some keyword, the table would sorted (only show the row that have that keyword), and if possible that he enter it few keyword.

keyword example VB, oracle

table example

project description
school making oracle dtbase
<blank> VB project
java database

when he enter vb, oracle then the table become

project description
school making oracle dtbase
<blank> VB project

any idea how? or someone would mind to give me example/make what the macro would like?
since i never use VB before it really difficult for me to built it from scratch..

thanks for your help

**Leith Ross** · 11-14-2008, 05:22 PM

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

**genki** · 11-14-2008, 10:17 PM

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..

**Leith Ross** · 11-14-2008, 11:50 PM

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

**genki** · 11-15-2008, 12:09 AM

i think all coloumn, but the result base one row that have that keyword
is that possible? i havent get any luck finding sample of that kind of macro

i think it's like using Find (ctrl+F) but it could filter the data

thanks,

**genki** · 11-17-2008, 03:51 AM

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?

keyword filtering

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

keyword filtering

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions