VBA (Macro) - Search Column in List for Specific words and delete rows that don't match.

[turtle_solver]

Hi All -

I am working on a hopefully simple macro, but would like some help to get started.

Summary of what I would like the macro to do below:

Original Sheet Contains:
- List in columns A through W (Size may change)
- Number of rows in list changes daily.

1. Seach Column D for specific words within the cells. (ex. Candy Or Nachos)
- Note: Rows in Column D may include text such as "Candy - Chocolate". This is would return true because it match Candy.

2. Delete all Rows that don't match the criteria.

3. Then create a new Sheet named "Candy" with only the rows that matched the Candy Criteria and a new sheet named "Nachos" with the rows that matched the Nachos Criteria.



Note: I would need Row 1 (Column Headers) to be copied in the Candy & Nachos sheet.

The final result would be as follows:

Summary Sheet (Original sheet)
- Contains all the rows that matched the criteria in Column D.

Candy Sheet
- Only the rows that matched "Candy" in Column D

Nachos Sheet
- Only the rows that matched "Nachos" in Column D

I would appreciate any help.

Manny