Hi,
Tricky task, but I want to create a macro that randomly pairs all names in a column without any repeats, then it will draft and send email to each of those pairs.
but.. then I want to be able to perform this same action again a month later, but not have any repeats of the previous month, until all possible combinations are exhausted.
I have added an example worksheet with manually sorted lists and some comments to explain the order of actions.
Any clues on how to even start this? maybe it's worth solving the pairing aspect first, without the emailing - then add that later/separately?
Any help appreciated.
Tricky task, but I want to create a macro that randomly pairs all names in a column without any repeats, then it will draft and send email to each of those pairs.
but.. then I want to be able to perform this same action again a month later, but not have any repeats of the previous month, until all possible combinations are exhausted.
I have added an example worksheet with manually sorted lists and some comments to explain the order of actions.
Any clues on how to even start this? maybe it's worth solving the pairing aspect first, without the emailing - then add that later/separately?
Any help appreciated.