Working on a staff roster programme in excel trying to do as follows.
In one worksheet have a key to work to being in fortnightly intervals with staff rotating between shifts.
In another sheet have the working roster i want to input names from key to working roster by the fortnight start date.
example of key.
date1 date2 date3 date4
names names names names
if i input say date2 into working roster how can i put those names to the roster.
Thanks in advance.
In one worksheet have a key to work to being in fortnightly intervals with staff rotating between shifts.
In another sheet have the working roster i want to input names from key to working roster by the fortnight start date.
example of key.
date1 date2 date3 date4
names names names names
if i input say date2 into working roster how can i put those names to the roster.
Thanks in advance.
