C
cox ng \(1\)
I need help in connecting cells and rows from one spreadsheet with multiple
tabs to another spreadsheet with multiple tabs. The first spreadsheet is
called "Time Sheet" (TS) and the second spreadsheet is called "Annual
Report" (AR).
Each tab on the TS has 25 employee names in a column with each employee
having a row containing 19 cells for information like hours, overtime, etc.
There are 3 rows for each employee representing 2 work weeks and 1 total.
There are 21 tabs in TS representing 21 two work week periods to make up one
year. Another words, each year on January 1st we will start with a new TS.
Each tab is identical other than the dates.
Each tab on the AR has 52 dates in a column with each date having a row
containing 19 cells for information like hours, overtime, etc. There are 25
tabs in AR representing 25 employees.
Each day we type into the TS cells the hours for each employee and any other
applicable information in the other cells. Each week we type into the AR
cells the applicable totals from the TS.
Is there a formula or conditional format that would automate the process?
If Billy works 47 hours the week ending 3/18/2007, the number typed into TS
would automatically show in Billy's tab in the AR. If Johnny works 43 hours
the same week, the number in TS would automatically show in Johnny's tab in
the AR. The following weeks we would repeat the process except there would
be a new tab in the AR every 2 weeks.
Windows XP
Excel XP
Thank you for any help you can offer,
Gary
tabs to another spreadsheet with multiple tabs. The first spreadsheet is
called "Time Sheet" (TS) and the second spreadsheet is called "Annual
Report" (AR).
Each tab on the TS has 25 employee names in a column with each employee
having a row containing 19 cells for information like hours, overtime, etc.
There are 3 rows for each employee representing 2 work weeks and 1 total.
There are 21 tabs in TS representing 21 two work week periods to make up one
year. Another words, each year on January 1st we will start with a new TS.
Each tab is identical other than the dates.
Each tab on the AR has 52 dates in a column with each date having a row
containing 19 cells for information like hours, overtime, etc. There are 25
tabs in AR representing 25 employees.
Each day we type into the TS cells the hours for each employee and any other
applicable information in the other cells. Each week we type into the AR
cells the applicable totals from the TS.
Is there a formula or conditional format that would automate the process?
If Billy works 47 hours the week ending 3/18/2007, the number typed into TS
would automatically show in Billy's tab in the AR. If Johnny works 43 hours
the same week, the number in TS would automatically show in Johnny's tab in
the AR. The following weeks we would repeat the process except there would
be a new tab in the AR every 2 weeks.
Windows XP
Excel XP
Thank you for any help you can offer,
Gary