Random Name Pairing (Macro or Forumla)

Hi All:

Hoping for some advise on how to create a list of randomly paired names based on two different positions (director and manager). It's for a duty roster, so the names will repeat to cover a year.

These are the notes I put in the sample spreadsheet:
Goal is to randomly pair Dir to manage to create a list of duty for the week starting in Col E.
There are 14 directors and 28 managers (currently)
Director names will repeat 3-4 times for the year, managers will repeat 3-4 times.
But would prefer directors weren't paired to the same manager; meaning each director manager pairing is unique.
Would like a macro or formula to create the pairings in Col F and G.

I was able to get close by assigning random numbers to each name, but it leave the issue of giving too many to one person and not enough to the other. I can do all this manually, but was hoping for a way to modify. Thoughts?

As always, thank you for any insights.

Whh3