Hi Everyone,
Probably you’re not going to understand what I’d like, but I try to explain. Please help if you could.
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.
![](/board/proxy.php?image=http%3A%2F%2Fkephost.hu%2Fthumb-984A_4F42CC0D.jpg&hash=de924bec7a139e8fc070b07a25a80347)
What I need, a macro which is gather the predefined text variatons by me of cells from column „A”, for eg:
HP Toner LJ5L/6L/3100/3150 CCA, black, 2500/sheet.
HP Toner LJ5L/6L/3100CCA, black, 2500/sheet.
HP Toner LJ5L/6L/RED 2500/sheet.
ASUS Motherboard/ and so on
and add the result for column „E” in result worksheet as specified item of category.
![](/board/proxy.php?image=http%3A%2F%2Fkephost.hu%2Fthumb-23A3_4F42CC0D.jpg&hash=140624357e9f7dd9df2242baf908cac7)
The main key is, I would like to determine what text variations(product's specifiaction) belongs for which category. Is it make sense??Maybe is it possible way, I just wondering.. generating somehow for e.g.: if text found "toner" then copy to column E in wroksheet result in same row...
If anybody have a best approach how can I solve this problem and abopt this method the rest of tables with macro or pivot table I would be appreciated. What is usual way? How can I reduce this tedious work??(in this case about 15000 row)
Thanks in advance
Probably you’re not going to understand what I’d like, but I try to explain. Please help if you could.
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.
![](/board/proxy.php?image=http%3A%2F%2Fkephost.hu%2Fthumb-984A_4F42CC0D.jpg&hash=de924bec7a139e8fc070b07a25a80347)
What I need, a macro which is gather the predefined text variatons by me of cells from column „A”, for eg:
HP Toner LJ5L/6L/3100/3150 CCA, black, 2500/sheet.
HP Toner LJ5L/6L/3100CCA, black, 2500/sheet.
HP Toner LJ5L/6L/RED 2500/sheet.
ASUS Motherboard/ and so on
and add the result for column „E” in result worksheet as specified item of category.
![](/board/proxy.php?image=http%3A%2F%2Fkephost.hu%2Fthumb-23A3_4F42CC0D.jpg&hash=140624357e9f7dd9df2242baf908cac7)
The main key is, I would like to determine what text variations(product's specifiaction) belongs for which category. Is it make sense??Maybe is it possible way, I just wondering.. generating somehow for e.g.: if text found "toner" then copy to column E in wroksheet result in same row...
If anybody have a best approach how can I solve this problem and abopt this method the rest of tables with macro or pivot table I would be appreciated. What is usual way? How can I reduce this tedious work??(in this case about 15000 row)
Thanks in advance