I want to filter specfic words from the list of that I have

**Kiran Kurapati** · 03-13-2013, 04:27 AM

Hi

I have a list of words I want to search and pull a specific words from this list and place them in a column B.

I have two sheets in the sample

Sheet1 with the companies list
Sheet2 with the words I want to place against the companies

In simple I use filter and saying contains I will get all the suppliers which contains that specfic word. But this to happen for all the words that
I have in the sheet using macro

Kindly Help me

Regards,
Kiran Kumar

**:) Sixthsense :)** · 03-13-2013, 04:47 AM

Try the below code

Please Login or Register  to view this content.

**Kiran Kurapati** · 03-13-2013, 05:28 AM

Thank you for the code, I have tried the code but nothing has happend... Is there something that I have do in code

**:) Sixthsense :)** · 03-13-2013, 05:35 AM

Open the attached excel and press Alt+F8 and select SelectDataInAutofilter() and click run.

**Kiran Kurapati** · 03-13-2013, 06:37 AM

Hi

Thanks for you help. I have tired the way you suggested but it didnt work.

Let me explain it to you

Lets say I have a supplier with name containing car in column A... Kiran Car Rental Supplier in sheet 1

Now when I run a Macro I need to get the word "Car" Against the name Kiran Car Rental Supplier in Column B

Kindly help me

Thank you

Regards,
Kiran Kumar