Hello all,

I have been asked to help come up with a simple workbook to help with
scheduling my section at work. Here is what I got so far

Sheet One = Schedule
with the following columns

<WeekDay><Date><Employee><Hours><Location><Week><Type><Assignment><ShiftID>

Sheet Two = Time Off
with the following columns

<Employee><Date><AbsenceType><Approved><ApprovedBy>

Here's what I'm trying to do.

1) When a Employee is entered into sheet one, check sheet to for time off,

if there is time off text colour red.

would this be pssible and what method should I be looking at?

2) Print a chart. Filtering <week> in sheet one, print a chart for one
week with <employee> on left side, <WeekDay> across the top, and Hours in
the chart?

any help would be appreciated.

Helder