Sort and assign VBA

tblazers1 Posts 1 Registration date Wednesday May 17, 2017 Status Member Last seen May 17, 2017 - May 17, 2017 at 10:49 AM

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.