Please bear in mind that my work computer is still in the dark ages and I only have acess to Excel 2003!
What I am trying to achieve is an overview of what day of the week someone has completed as the duty person. i.e. In each month someone will do a duty on a Monday and on another month it could be a Friday. Effecitvely I am trying to aleviate someone doing a duty recurrently on the same day.
I have set the workbook up with the following worksheets: Overall, Jan, Feb, Mar, (all the way through to) Dec.
In all the worksheets I have A1 empty, B1 has Mon, C1 has Tue, D1 has Wed, E1 has Thur, F1 has Fri, G1 has Sat, H1 has Sun and A2 downwards has everyone's names.
Hopefully someone can help me solve this one.
What I am trying to achieve is an overview of what day of the week someone has completed as the duty person. i.e. In each month someone will do a duty on a Monday and on another month it could be a Friday. Effecitvely I am trying to aleviate someone doing a duty recurrently on the same day.
I have set the workbook up with the following worksheets: Overall, Jan, Feb, Mar, (all the way through to) Dec.
In all the worksheets I have A1 empty, B1 has Mon, C1 has Tue, D1 has Wed, E1 has Thur, F1 has Fri, G1 has Sat, H1 has Sun and A2 downwards has everyone's names.
Hopefully someone can help me solve this one.