Spreadsheet: 49466d1248816548-auto-populating-columns-in-one-sheet-from-another-based-on-criteria-example-work-schedule-autofill
Sheet: JUN (4A)

Work Schedule
JUNE 2009
 |  |  |  |  |  |  |  |  |  | S | S |  |  |  |  |  | S | S |  |  |  |  |  | S | S |  |  |  |  |  | S | S
 |  |  |  | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W
 |  |  |  | 2009-05-31 00:00:00 | 2009-06-01 00:00:00 | 2009-06-02 00:00:00 | 2009-06-03 00:00:00 | 2009-06-04 00:00:00 | 2009-06-05 00:00:00 | 2009-06-06 00:00:00 | 2009-06-07 00:00:00 | 2009-06-08 00:00:00 | 2009-06-09 00:00:00 | 2009-06-10 00:00:00 | 2009-06-11 00:00:00 | 2009-06-12 00:00:00 | 2009-06-13 00:00:00 | 2009-06-14 00:00:00 | 2009-06-15 00:00:00 | 2009-06-16 00:00:00 | 2009-06-17 00:00:00 | 2009-06-18 00:00:00 | 2009-06-19 00:00:00 | 2009-06-20 00:00:00 | 2009-06-21 00:00:00 | 2009-06-22 00:00:00 | 2009-06-23 00:00:00 | 2009-06-24 00:00:00 | 2009-06-25 00:00:00 | 2009-06-26 00:00:00 | 2009-06-27 00:00:00 | 2009-06-28 00:00:00 | 2009-06-29 00:00:00 | 2009-06-30 00:00:00 | 2009-07-01 00:00:00
Employee 1 |  |  |  | O |  |  |  |  |  | O | O |  |  | L | L | L | O | O |  |  |  |  |  | O | O |  |  |  |  |  | O | O
Employee 2 |  |  |  | O |  |  |  |  |  | O | O |  |  |  |  |  | O | O |  |  |  |  |  | O | O |  |  |  |  | L | L | L | L
Employee 3 |  |  |  | O |  | L |  |  |  | O | O |  |  |  |  |  | O | U | L | L | L | L | L | L | L | L | L | X | Z |  | O | O |  |  | X
Employee 4 |  |  |  | O | N | N | N | N | N | O | O |  |  | X | Z | O | O | X | Z |  |  |  |  | O | O |  |  |  |  | O | O | X | Z
Employee 5 |  |  |  | O | X | Z | I |  | X | Z | O | O |  |  |  |  | O | O |  | X | Z | N |  | O | O |  | N | N | L | L | L | L | . | . | .
Employee 6 |  |  |  | N |  | X | Z |  |  | O | O |  |  |  |  | X | Z | O | O |  |  |  | O | O | X | Z |  |  |  | L | L | L
Employee 7 |  |  |  | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | .
Employee 8 |  |  |  | O | O |  | I | L | X | Z | O | O |  |  | N |  | O | O |  |  |  | N |  | O | O | L | X | Z | N | O | X | Z | O
Employee 9 |  |  |  | X | Z |  | I | L | O | D | O | X | Z |  |  |  | X | Z | O |  |  | O | X | Z | O | O |  |  |  |  | O | O
Employee 10 |  |  |  | O | O | N | N | N | N | X | Z | O | O |  | X | Z | O | O |  |  |  | X | Z | O | O |  |  |  |  | X | Z | O | O
Employee 11 |  |  |  | U | N |  |  | X | Z | O | O |  |  |  |  | L | L | L |  |  | X | Z |  | O | O | X | Z |  | X | Z | O | O
Employee 12 |  |  |  | O |  |  |  | X | Z | O | O |  | X | Z |  |  | O | O |  | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | .
Employee 13 |  |  |  | Z | O |  | X | Z | N | N | L | L | T | T | T | T | T | O | O | X | Z | N | O | X | Z | O |  |  |  | L | L | L | X | Z
Employee 14 |  |  |  | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | .
Employee 15 |  |  |  | O |  |  | N | N | O | O | X | Z | N |  |  |  | N | N | X | Z |  |  |  | N | N | X | Z | L | L | L | O | O |  | X | Z
Employee 16 |  |  |  | Z | O |  |  | N | O | X | N | O |  |  | N | L | O | N | X | Z |  | X | Z | O | N |  | X | Z | N |  | O | O | X | Z
Employee 17 |  |  |  | M | M | M | L | L | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M
Employee 18 |  |  |  | T | T | O |  |  |  | O | O |  |  | X | Z | O | X | Z | O |  |  |  | X | Z | O | O | L |  |  | O | X | Z | O
Employee 19 |  |  |  | N | X | Z |  |  | N | D | O | O | X | Z |  | O | O | X | Z |  |  |  |  | O | O |  |  |  | X | Z | O | O |  |  | X
Employee 20 |  |  |  | L | L | N | X | Z | O | O | T | T | T | T |  |  | N | O |  |  | X | Z | O | X | Z | O |  | X | Z |  | O | O |  | X | Z
Employee 21 |  |  |  | L | L | X | Z |  | O | O | X | Z |  |  | X | Z | L | L | L | L | L | L | L | L | L | L | L | L | L | O | O | X | Z
Employee 22 |  |  |  | X | Z |  |  |  |  | O | O | X | Z |  |  | X | Z | O | O |  |  |  | O | O | X | Z |  |  |  | X | Z | O | O
Employee 23 |  |  |  | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T | T
 |  |  | Avail: | 0 | 10 | 15 | 14 | 15 | 12 | 0 | 0 | 10 | 14 | 14 | 15 | 10 | 0 | 0 | 10 | 14 | 14 | 13 | 10 | 0 | 0 | 9 | 13 | 14 | 13 | 7 | 0 | 0 | 10 | 15 | 15
 |  |  |  | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
LEGEND |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAD:
 | X | Duty (relief @ 1345) |  |  |  |  |  | M | Medical
 | Z | Off-going duty |  |  |  |  |  | N | Request no duty  (personal)
 | O | Off Day/ Slider |  |  |  |  |  | U | Unavailable (out of town)
 | R | Dog Watch (Ready) |  |  |  |  |  |  | No duty  (Cmd designated)
 | L | Leave |  |  |  |  |  |  | In transition/PCS
 | T | TAD |  |  |  |  |  |  | Weekend/ Holiday
 | I | RW Air Intercept |  |  |  |  |  |  | Schedule change from original
 | D | DLQ's |  |  |  |  |  |  | Req duty
 | P | Public Affairs |  |  |  |  |  |  | Standby Ready (B2)