Students seats

[Chliapas Dimitrios]

Good evening,
i am new to vba and would like your valuable advice.
I am a teacher and I have a class with 14 students.
I want the students to sit with a different student every day.
I have the pairs of students and I want to rank them all in the five working days periodically but not repeat.
How can I achieve this using vba?
I am attaching the example.
Thanks in advance for your valuable help.

 

[Chliapas Dimitrios]

Thank you very much that even though the thread is closed you continue to help me and perfect the already perfect result. You are a perfectionist and this is a great asset and I congratulate you.
Thank you.
Be well.