Copy rows based on keyword list to second sheet

[warlock666999]

Hello all, I have an excel sheet with a list of software names on column A and column B has the version number and column C has department name. I want to copy the rows that contain keywords that I have on a third sheet such as acrobat, word, AnyConnect etc on sheet 1 Column A to the second sheet. I would rather have a macro since I have many sheets from different machines.

 

[Fluff]

Glad we could help & thanks for the feedback