VBA to extract duplicates and copy in separate files

[JW Tajonera]

Hi,

For someone who is up to a challenge and unlike me who only has basic knowledge about VBA. I need help to create a macro that will do the following:

I am currently doing a project where I need to create a report and email them automatically using vba. Below is a sample of the raw data.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name [/TD]
[TD]Executor[/TD]
[TD]ID[/TD]
[TD]Data 2[/TD]
[TD]Email address[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]IE[/TD]
[TD]0001[/TD]
[TD]a[/TD]
[TD]sample1@example.com[/TD]
[/TR]
[TR]
[TD]Jane[/TD]
[TD]DR[/TD]
[TD]0001[/TD]
[TD]b[/TD]
[TD]sample2@example.com[/TD]
[/TR]
[TR]
[TD]Jude[/TD]
[TD]DR[/TD]
[TD]0002[/TD]
[TD]a[/TD]
[TD]sample3@example.com[/TD]
[/TR]
[TR]
[TD]Jake[/TD]
[TD]IE[/TD]
[TD]0004[/TD]
[TD]b[/TD]
[TD]sample4@example.com[/TD]
[/TR]
[TR]
[TD]Julie[/TD]
[TD]IE[/TD]
[TD]0002[/TD]
[TD]b[/TD]
[TD]sample5@example.com

[/TD]
[/TR]
</tbody>[/TABLE]

To create the report I need to be able to extract entire row of matched/duplicate data in Column C (ID) and copy them in separate excel files (i.e. base on sample data, extract entire row of entries for ID 0001 and copy it in one file, then 0002 in another so on so forth) using the IDs as file name while the worksheet where the data is copied should be named as "Raw Data."

After the matched data are copied into individual files. I need to insert the reporting template from a different file into each of the individual files (or maybe we could copy the report template into the new file the same time it copies the duplicate/match data into the "raw data" worksheet).

After the report templates are added I need to email the report to email addresses of the Dr's under the executor column.

I would really appreciate any help you can provide.

Thank you.