Spreadsheet: 275485d1383543749-need-to-copy-all-data-for-each-week-and-compile-to-one-sheet-for-year-to-date-data-consolodate-weeks-sheets-to-summary-sheet-ver-2
Sheet: YTD

Enter Start Date
Date | Employee# | Name | task | # of hour |  | Wk No | Wk Day |  | count
2013-12-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2013-12-30 00:00:00
2013-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2013-12-31 00:00:00
2014-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-01 00:00:00
2014-01-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-02 00:00:00
2014-01-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-03 00:00:00
2014-01-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-03 00:00:00
2014-01-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-03 00:00:00
2014-01-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-04 00:00:00
2014-01-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-06 00:00:00
2014-01-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-07 00:00:00
2014-01-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-08 00:00:00
2014-01-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-09 00:00:00
2014-01-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-10 00:00:00
2014-01-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-10 00:00:00
2014-01-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-10 00:00:00
2014-01-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-11 00:00:00
2014-01-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-13 00:00:00
2014-01-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-14 00:00:00
2014-01-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-15 00:00:00
2014-01-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-16 00:00:00
2014-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-17 00:00:00
2014-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-17 00:00:00
2014-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-17 00:00:00
2014-01-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-01-18 00:00:00
*** This would keep going until the end of year. See below.***
2014-12-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-12-08 00:00:00
2014-12-09 00:00:00 | 2222 |  | [NAME] | 10 |  |  |  |  |  |  |  | 2014-12-09 00:00:00
2014-12-10 00:00:00 | 3333 |  | Task1 | 8 |  |  |  |  |  |  |  | 2014-12-10 00:00:00
2014-12-11 00:00:00 | 4444 |  | Task1 | 10 |  |  |  |  |  |  |  | 2014-12-11 00:00:00
2014-12-12 00:00:00 | 1111 |  | Task1 | 8 |  |  |  |  |  |  |  | 2014-12-12 00:00:00
2014-12-12 00:00:00 | 2222 |  | [NAME] | 8 |  |  |  |  |  |  |  | 2014-12-12 00:00:00
2014-12-12 00:00:00 | 4444 |  | Task1 | 10 |  |  |  |  |  |  |  | 2014-12-12 00:00:00
2014-12-13 00:00:00 | 3333 |  | Task1 | 8 |  |  |  |  |  |  |  | 2014-12-13 00:00:00
2014-12-15 00:00:00 | 1111 |  | [NAME] | 8 |  |  |  |  |  |  |  | 2014-12-15 00:00:00
2014-12-16 00:00:00 | 2222 |  | Task1 | 10 |  |  |  |  |  |  |  | 2014-12-16 00:00:00
2014-12-17 00:00:00 | 3333 |  | Task1 | 8 |  |  |  |  |  |  |  | 2014-12-17 00:00:00
2014-12-18 00:00:00 | 4444 |  | [NAME] | 10 |  |  |  |  |  |  |  | 2014-12-18 00:00:00
2014-12-19 00:00:00 | 1111 |  | Task1 | 8 |  |  |  |  |  |  |  | 2014-12-19 00:00:00
2014-12-19 00:00:00 | 2222 |  | [NAME] | 8 |  |  |  |  |  |  |  | 2014-12-19 00:00:00
2014-12-19 00:00:00 | 4444 |  | [NAME] | 10 |  |  |  |  |  |  |  | 2014-12-19 00:00:00
2014-12-20 00:00:00 | 3333 |  | [NAME] | 8 |  |  |  |  |  |  |  | 2014-12-20 00:00:00
2014-12-22 00:00:00 | 1111 |  | Task1 | 8 |  |  |  |  |  |  |  | 2014-12-22 00:00:00
2014-12-23 00:00:00 | 2222 |  | Task1 | 10 |  |  |  |  |  |  |  | 2014-12-23 00:00:00
2014-12-24 00:00:00 | 3333 |  | [NAME] | 8 |  |  |  |  |  |  |  | 2014-12-24 00:00:00
2014-12-25 00:00:00 | 4444 |  | Task1 | 10 |  |  |  |  |  |  |  | 2014-12-25 00:00:00
2014-12-26 00:00:00 | 1111 |  | Task1 | 8 |  |  |  |  |  |  |  | 2014-12-26 00:00:00
2014-12-26 00:00:00 | 2222 |  | Task1 | 8 |  |  |  |  |  |  |  | 2014-12-26 00:00:00
2014-12-26 00:00:00 | 4444 |  | Task1 | 10 |  |  |  |  |  |  |  | 2014-12-26 00:00:00
2014-12-27 00:00:00 | 3333 |  | [NAME] | 8 |  |  |  |  |  |  |  | 2014-12-27 00:00:00