thank you for this amazing website.
i need some help with excel issue , it might be easy from some but i couldn’t get it to work with me.
i work in a 24/7 dep i want excel to put whoever in the morning ,evening and night shift in a handover page automatically, i know i need to use macros , but i can’t figure out what is the code to put so it doesn’t repeat the same names as there is more than 1 person a each shift sample this is a sample of the schedule and handover page, i really appreciate your help
M= Morning E= Evening N=Night O= Off Days
so far i have tried to use the IF , AND & OR rule
but i can not find a way to tell it to skip the names already selected
By: Houssam Eltouny