Sort and assign VBA [Closed]

tblazers1 1 Posts Wednesday May 17, 2017Registration date May 17, 2017 Last seen - May 17, 2017 at 10:49 AM - Latest reply: Ambucias 51171 Posts Monday February 1, 2010Registration dateModeratorStatus April 24, 2018 Last seen
- May 17, 2017 at 05:41 PM
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.
See more 

1 reply

Ambucias 51171 Posts Monday February 1, 2010Registration dateModeratorStatus April 24, 2018 Last seen - May 17, 2017 at 05:41 PM
0
Helpful
Greetings,

Please, bare in mind that CCM is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Hence we request that CCM forum users show mutual respect. Therefore, when asking for assistance, please be courteous, as for elsewhere in similar circumstances in every day society when asking for help. (Usually, how would someone ask for help? i.e. please, thank you, appreciate, grateful, etc.)

Being courteous will also increase your chances of getting the help you need.

http://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator