I'm trying to do a roster pattern which involves each person doing the same
but one day out of phase with the previous person.

Basically, I need to fill a cell with the value in the cell one columnback
and one row up (or sometimes 3 up and 3 back). In this way I can roster all
19 people without retyping each line.

I'm not quite sure how to manipulate cell references to do this. Please
could someone advice me?

many thanks IA