Okay.. see the attached file - yellow highlighted row where I obtained results for multiple clients. Thanks.

Sample A - Staff Rota with macro.xlsm

Regards,
DILIPandey
<click on below * if this helps>