| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking worksheets | Excel Discussion (Misc queries) | |||
| linking worksheets | Excel Worksheet Functions | |||
| Linking Worksheets | Excel Worksheet Functions | |||
| Linking worksheets | New Users to Excel | |||
| linking worksheets | Excel Worksheet Functions | |||
Hybrid Mode
