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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!