|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
linking worksheets
GOT IT!!! :)
"T. Valko" wrote:
My example does exactly what you've asked for. The only difference is that I
didn't use 2 sheets.
Change the shifts around in B5:B7 then change the date in A11 to 5/8/2007
and see what happens.
Biff
"SociologyStudent" wrote in
message ...
Thanks!
But I need to be able to input the date on a separate worksheet and have
it
return the names of the people working specific shifts from the employee
schedule.
I have the week ending date in F1. that date updates the dates for one
entire week. I then update each day of the week for each employee.
Employee
names are listed in column A.
On a separate worksheet, I want to be able to input the date 5/10 in one
cell and then have the worksheet populate cells designated for the 7-3
shift
with the appropriate names, then 3-11 then 11-7
"T. Valko" wrote:
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.
|