linking cells with scheduling workbook

M

MattSwift

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Employee Scheduling Worksheet 10
Linking cells on different sheets within a workbook. 1
list sheet 1 - same cell (eg A1) in a group of worksheets sheet 2
Resource Scheduling/loading 1
lookup with match 4
Daily Time Sheets with Rounding 1
Match a value to multple criteria both in rows and columns 3
Pulling From Multiple Sheet 0

Top