what i want is:

a1-a48 different names
b1-n1 different shifts, etc: morning shift, afternoon shift,
night shift, rdo
b2-n2 different shifts again,different as b1-n1
all the way to line 48

every saturday fornight week, we work drop 1 line, say if my name in a1
this fornight, saturday 2 weeks later, my name will be on line 2(b2-n2).
and person in a48 will be in a1.
how can i do it so every 2nd saturday when i open the workbook, it
automaticaly change to new line which i suppose to be.

thanx


--
jinvictor
------------------------------------------------------------------------
jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099
View this thread: http://www.excelforum.com/showthread...hreadid=548256