VBA / Macro to filter through 2 different columns in table using multiple key words and then copy the rows of the table to a separate sheet.

[Jack_Mason]

I would like to code a macro to filter through column H, S and AH in a database which is in columns E to AW using keywords which are found in C2 to C25 and then copy the table row to a separate sheet for each keyword. preferably without copying duplicates.

Table ranges from E to AW
Keywords are in cells C2 to C25
Table is on sheet1

Sorry i cant upload a photo. Every photo I upload is apparently too large

 

[Fluff]

Duplicate Macro to filter and copy to another sheet.

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).