I have the attached file i would like to rotate the names to drop them down each week and move the one on the bottom to the week 1 slot that is vacated

point 2 W.xls

point 2 i need to be able to rotate the dates so i can input a date in the top box and it will rotate the names to the current shifts for all the staff for that week

and displays the proper datacross the top for the week selected

hope this is clear

paul