ref tables

Hello All,
I don't know if I'm asking the impossible here but I'll give
it a try. I have a excel program which I am trying to set up a function
whereby it will create a work rota based on a shift pattern. It currently
will create a table with staff names on it and there shift pattern for a
given week. What I am trying to do is let the user select shift pattern 1
for example and have excel transfer this onto the rota but place the name
instead of shift in the appropriate shift. ie If I select shift 1 it will
place name A onto the early shift and place A on the Day off line which in
this case is Friday.The actual rota has 14 staff on it per day, seven days a
week. Some are early, some back and some off. I hope I have explained it
clearly but knowing me probably not. Thanks for taking the time to look at
it
Colin



Name Shift
Sun Mon Tues Wed Thur Frid Sat
1 A E E E E Off E E


2 B B B B Off B B B
Early Shift 1 A A A A A A


Back Shift 2 B B B B B B


Day Off B A