Using an Excel 2003 macro.
I'm trying to copy a range of unique names (POCs point of contacts) to another sheet and it works fine. But what I'd like to do is copy the unique names to the other sheet only IF there is a "YES" in the next column (called Send Notification). I'm using Ron Debruin's excellent code in his "Mail a row or rows to each person in a range (SendMail).

Here's is a snippet. Let me know if you need more information

  Set POCSheet = Worksheets.Add
    FilterRange.Columns(FieldNum).AdvancedFilter _
    Action:=xlFilterCopy, _
    CopyToRange:=POCSheet.Range("A1"), _
    CriteriaRange:="", Unique:=True
Can someone help me out on this please. I'm a struggling newbie to vb.

Thank you in advanced.

cjaye