hi,

i am using an excel worksheet for an employee schedule for about 60 people.
i need to make a daily workload for each day of the week and print it. i
inserted 7 worksheets within my sched worksheet. for sunday which will be say
sheet 1, if i enter an employee for that day, i want the worksheet to pickup
the shift and dept for that employee. eg if i enter in a1 in workshhet 1
"bob" whose name is on a29 in the sched worksheet, i need a2 and a3 in sheet
1 to pickup bob's shift and dept which is e29 and e30. and the same for the
names i enter down the list. the names i enter may be in random order. eg bob
(a29), joe (a31), pat (a47), tim (a131), etc
any ideas? thanks in advance