The example.xls file is located :http://www.box.com/s/ibrceu93p3c7taxdgxl6
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.
What I need, a macro which is gather the predefined text variatons by me from cells of column ?A?, for eg:
X igmatek NRPPC
Xigmatek NK-602 ab cde
..decide match or not, if so, add the result to column ?E? in "required result" worksheet in specified item of category.
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)