Sort and assign VBA

Hello,

I am trying to sort a column of Y and N i have in a chart on worksheet 1 in VBA. The list changes hourly. Once I determine who has a Y or N, I need to assign them a task from a predetermined list from another worksheet that is sent out in an automated email. I have gone through a lot of loops and was wondering if there was an easier way to code this in VBA because the list updates hourly.