Assign an agent to customer based on language and loop - VBA

Good morning,
I'm trying to find some help, hope it's the right place :-)

I have 2 sheets -
On the first (Customers) - I have a list of customers that i need to call them back (including their language).
On the second (Agents) - I have a list of agents with their language skills.

I want to create a macro that will 'assign' an agent to each customer based on the language,
In most cases i will have more customers than agents and i want to loop the agents based on their language.
(The yellow part in the attached document is what i'm aiming for).

Example.xlsm

The process is much longer but i'm struggling only with that part at the moment.

Thanks a lot!

Ori

Hi PCI,
Yes, there may be only 5 agents for the same language but 10 customers, i want to assign the agents in a way that each agent will have 2 customers in that case:
Customer 1 - Agent 1
Customer 2 - Agent 2
Customer 3 - Agent 3
Customer 4 - Agent 4
Customer 5 - Agent 5
Customer 6 - Agent 1
Customer 7 - Agent 2
Customer 8 - Agent 3
Customer 9 - Agent 4
Customer 10 - Agent 5

Thanks

Any ideas? please?

Aww..cool!!
I'm sorry, I wasn't sure if someone is working on it...

Thank you :-)

You are amazing!!!!!

I found only one issue - When i have the same language repeating more times than the amount of agents, the same agent will appear twice in a row.

For example, for Spanish customers, from the fourth customer the code will assign the first agent again:

Customer: Agent:
First Customer - Daniel
Second Customer - Maxim
Third Customer - Daniel
Fourth Customer - Daniel (again)

The example file attached here - Example2.xlsm

In the actual list i have thousands of customers and hundreds of agents in many more languages, i'm trying to divide the customers equally if possible...

Thanks a lot again!! Much appreciated!

Yes, we can have a lot of customers and a lot of agents per each language, depends on the hour of the day
(This macro will be the next step after my first report that tells me who is currently in the business).

Generally the full process will be:
1. Identify who is in the business (agents)
2. Identify which customers are waiting for a call back (Customers)
3. Assign online agents to customers
4. Send an email to the agents with the customer details
5. Keep a record with all the data (for tracking)

I'm building each part separately and i already have the most of it, just need to do some fixes and combine them.

Thanks

Perfect! you are genius!!
I will try it wish some real data on Monday and let you know :-)

Thank you very much and have a great weekend!!

Ori