How to copy rows where a single cell matches certain criteria?

[Sccye]

Hi all,

I currently maintain a fairly standard Risk, Issue and Action log for a project. There are certain people that own each of these risks, issues etc... with their name stored per row in the 'Owner' column.

I want to write a macro that will skim through all the data, picking out each row that has a particular person in this column.

I then want it to copy each row it finds into a new worksheet.

Ultimately, I want it to copy all of these into a pre-set e-mail template and send them to the person of that name - but can figure out that aspect of it later.

The bit I'm stuck on for the moment is just getting it to do the search.

Any ideas?

Thanks!

[JBeaucaire]

'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.