Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Scheduling workbook
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<T ype<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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scheduling... | Excel Discussion (Misc queries) | |||
scheduling | Excel Worksheet Functions | |||
Scheduling | Excel Discussion (Misc queries) | |||
Time scheduling | Excel Worksheet Functions | |||
Scheduling | Excel Worksheet Functions |