Hi All,

I am new to this and I have been searching for a few days now to find a Macro that will look for a group of words which are basically a variation of the word Hardware. And return the whole row into another sheet in the book? So far I have found some code that I think should work, however it is not my code and I have tried to ammend the code to work for my scenario.

Does anyone have any suggestions on how to fix this to do what I have just explained? I have attached the sample Workbook and it has the current Macro code built in (the one that doesnt quite work) Currently it copies the top line to sheet two but does not search for the words and return the row in to sheet 2. The list of words I am looking to search for are on sheet3.

Thanks anyone for help on this problem

Kindest Regards

Ian.Sample Report with Macro.xlsx