linking worksheets
 

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.

linking worksheets
 

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.

linking worksheets
 

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.

linking worksheets
 

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.

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.

linking worksheets
 

Ok, good deal!

Biff

"SociologyStudent" wrote in
message ...
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.

linking worksheets
 

One more question:

How do I input this formula so it pulls from a schedule on WORKSHEET 2? I
don't want the managers to have to do anything to the schedule so I will hide
that. I only want them to have access to the one worksheet which will have
the daily schedule.



"T. Valko" wrote:

Ok, good deal!

Biff

"SociologyStudent" wrote in
message ...
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.

linking worksheets
 

Here's an updated file:

http://cjoint.com/?fjgCnUNTsn

It has 2 sheets. The formulas are on sheet1. The sched is on sheet2. Sheet2
is hidden. To unhide sheet2: goto FormatSheetUnhide

Biff

"SociologyStudent" wrote in
message ...
One more question:

How do I input this formula so it pulls from a schedule on WORKSHEET 2? I
don't want the managers to have to do anything to the schedule so I will
hide
that. I only want them to have access to the one worksheet which will have
the daily schedule.



"T. Valko" wrote:

Ok, good deal!

Biff

"SociologyStudent" wrote in
message ...
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.

linking worksheets
 

Thanks!

"T. Valko" wrote:

Here's an updated file:

http://cjoint.com/?fjgCnUNTsn

It has 2 sheets. The formulas are on sheet1. The sched is on sheet2. Sheet2
is hidden. To unhide sheet2: goto FormatSheetUnhide

Biff

"SociologyStudent" wrote in
message ...
One more question:

How do I input this formula so it pulls from a schedule on WORKSHEET 2? I
don't want the managers to have to do anything to the schedule so I will
hide
that. I only want them to have access to the one worksheet which will have
the daily schedule.



"T. Valko" wrote:

Ok, good deal!

Biff

"SociologyStudent" wrote in
message ...
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.

linking worksheets
 

You're welcome!

Biff

"SociologyStudent" wrote in
message ...
Thanks!

"T. Valko" wrote:

Here's an updated file:

http://cjoint.com/?fjgCnUNTsn

It has 2 sheets. The formulas are on sheet1. The sched is on sheet2.
Sheet2
is hidden. To unhide sheet2: goto FormatSheetUnhide

Biff

"SociologyStudent" wrote in
message ...
One more question:

How do I input this formula so it pulls from a schedule on WORKSHEET 2?
I
don't want the managers to have to do anything to the schedule so I
will
hide
that. I only want them to have access to the one worksheet which will
have
the daily schedule.



"T. Valko" wrote:

Ok, good deal!

Biff

"SociologyStudent" wrote
in
message ...
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.