Here's a small sample file:

Emp_sched.xls 14kb

http://cjoint.com/?fif2cqqOMb

Biff

"SociologyStudent" wrote in
message ...
I am trying to link hours input on one worksheet to appear on another
worksheet. For example:

Worksheet #1 Weekly schedule

Row 2 Tuesday May 8 Wednesday May 9
Cell A B C
Row 5 Employee A 3-11 Off
Row 6 Emploeey B 7-3 7-3
Row 7 Employee C 11-7 11-7

Worksheet #2 Daily Schedule

I need to be able to input May 9 in a cell and have A5 appear in the
section
for for the 3-11 shift , A6 in a section for 7-3 shift and B7 in a section
for 11-7.