Vba code to search key words in descriptions column

Hi All,
In sheet1 in column A i have a List of key words and in sheet2 in column B i have descriptions .
What I would like to do is this: I required a macro which would search all key words in cell B2 and if key words found then should paste these key words from D2 to xltoright and also counts of total key words found should come in Cell C2 and repeat same procedure for B3,B4 and so on so.
Please find the attached sample file.The output data is showing in sheet3.

Regards,

xlhelp7

Hi
its a bit long, but you can do this with a formula if you like - try this in cell C2 and copied to the cells below

Please Login or Register  to view this content.

or with a macro, try selecting cell c3 and running this (the results will look better if you format your cells in column C to "wrap text"

Please Login or Register  to view this content.

Hi NickyC/bakerman2,

Thank you for your reply!

bakerman2, that is exactly what I am looking for.

Perfect!!!! Thanks so much for your assistance.