Hi All,
I am having 2 workbooks. If workbook 1 "D" Col having some keywords, if that keyword is there in the workbook2 "C" Col sentence, it will copy workbook2 row values, and paste it into another workbook. In the Workbook 1 "D"Col some of keywords are more than 1 word, is it possible to take that keyword, and search it in the workbook2. i tried one code, in that i used directly specify the keyword name, but in future "D" Col will update , and new keywords will appear, that macro will not give the correct output.
if you see 3rd col is the -D Col, how to take those keywords, and search it in the Workbook 2 "C" col
for example: If visible cell is 3rd row in the image, it's having "EliteDesk", "EDK" , macro will search the workbook2 Col "C" whether any one these 2 words are there in the "C" Col .
is it possible to do.
I am having 2 workbooks. If workbook 1 "D" Col having some keywords, if that keyword is there in the workbook2 "C" Col sentence, it will copy workbook2 row values, and paste it into another workbook. In the Workbook 1 "D"Col some of keywords are more than 1 word, is it possible to take that keyword, and search it in the workbook2. i tried one code, in that i used directly specify the keyword name, but in future "D" Col will update , and new keywords will appear, that macro will not give the correct output.
| HP PL | Suffix w/out Option | Description Keywords |
| 7F | UT | EliteDesk, EON, EOT |
| GA | UT | EliteDesk, EDK |
| 9R | Smartbuy, SBY, Promo | |
| CY | Smartbuy, SBY, Promo | |
| MG | Smartbuy, SBY, Promo |
if you see 3rd col is the -D Col, how to take those keywords, and search it in the Workbook 2 "C" col
for example: If visible cell is 3rd row in the image, it's having "EliteDesk", "EDK" , macro will search the workbook2 Col "C" whether any one these 2 words are there in the "C" Col .
is it possible to do.
