Sort and assign VBA

[Closed]
Report
Posts
1
Registration date
Wednesday May 17, 2017
Status
Member
Last seen
May 17, 2017
-
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.