Gather multiple keyword and separate them to categories

[nehogy mar]

Hi everybody

Please help me

The example.xls file is located :http://www.box.com/s/ibrceu93p3c7taxdgxl6

Excel 2010

So my problem

I?ve 4 column table, let say source, in worksheet?source?. These tables comes from different companies. Unfortunatelly they have similar products, but mostly those has slightly different names. In this screen you can see one of the possible company's product list.

http://static.kepfeltolto.com/big/2012/02/21/351105064464ebe4d5020719d737786d.jpg

What I need, a macro which is gather the predefined text variatons by me from cells of column ?A?, for eg:

Xigmatek NRP-PC602
X igmatek NRPPC
Xigmatek NK-602 ab cde
Xigmatek Kp-12456...etc.

...decide match or not, if so, add the result to column ?E? in "required result" worksheet in specified item of category.

http://static.kepfeltolto.com/big/2012/02/21/a4ab0159d9964330749d0233fb5464e0.jpg

The main key is, I would like to determine what text variations(product's specifiaction) belongs for which category. Is it makesense??Maybe is it possible way, I just wondering.. generating somehow for e.g.: if text found "toner or tonerxyz or other text contatains toner" then add column E value: "Inkjet" as category in worksheet "reqired result" in same row...


Briefly i'd like to separate automatically the items and send them to the approprieate category.(In other words: What I want in excel it is called ?price routing? what price comparison script does, and I wish to remodeling how these process works in excel.)


If anybody have a best approach how can I solve this problem and abopt this method the rest of companie's tables with macro or pivot table I would be appreciated. What is usual way? How can I reduce this tedious work??(in this case I have about 15000 row)


Thanks in advance, for your kind effort

 

[merjet]

Have you considered using the menu Data | Filter? Using a custom
filter on column A, you can filter based on the Product Name
containing a particular characters string.
If you want a macro, use Record New Macro and then edit it to suit
your goal.

 

[Don Guillett]

Have you considered using the menu Data | Filter? Using a custom
filter on column A, you can filter based on the Product Name
containing a particular characters string.
If you want a macro, use Record New Macro and then edit it to suit
your goal.

I'm still not quite sure what you want in col E. Send a file to
dguillett1 @gmail.com with a complete explanation.