| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking cells with scheduling workbook
I have an Excel workbook for scheduling employees in several departments.
Each department has their own sheet and their scheduled days/times are linked to a comprehensive sheet so all employees and their schedule are shown on one sheet. The comprehensive sheet is printed and posted to everyone. The problem I am having is that if they have a day off and the cells for the starting and ending time is blank on the ind. department sheet, the cells display 12:00 AM on the comprehensive sheet. How do I program so that whenever an employee is not scheduled, that day is blank for their starting and ending time on the comprehensive sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking cells to other sheets within a workbook | Excel Discussion (Misc queries) | |||
| Linking different cells from one sheet to another in same workbook | Excel Discussion (Misc queries) | |||
| linking cells to another workbook | Excel Worksheet Functions | |||
| Scheduling workbook | New Users to Excel | |||
| workbook linking cells not working within a workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
