Master sheet to control whats shown on remaining sheets

What is the quickest way to set up a workbook where 1 sheet contains all data but remaining sheets show only specified items.

An example of this would be:

Job 1 runs Mon-Fri
Job 2 runs Mon-Thur
Job 3 runs Everyday

The master sheet would contain all 3 jobs. Sheets Mon, Tue, Wed, Thurs show all 3 as well. Sheets Friday contains only Job 1 and 3. Sheets Sat, Sun show only Job 3.


I have toyed with the idea of using an "If" statement saying if a cell used to show when a job runs contains everyday show the job in a specific cell in all sheets. If the same cell used to show when the job runs contains Mon-Fri show this job in a specific cell in specific sheets.

There must be an easier way though, right?

Why duplicate data? Wouldn't a filter on the main sheet work just as well?

Originally Posted by cytop

Why duplicate data? Wouldn't a filter on the main sheet work just as well?

Very good question. The sheets are actually printed to create 7 small booklets showing the jobs that need to run for each day. The goal here is to create a master sheet that automatically places jobs on their correct days, BUT the biggest issue is the people who will add to the master sheet from time to time are not tech savvy. I would like for the workbook to place the jobs on each sheet based on what Column B says (i.e. Everyday, Sat, Mon-Fri) with no intervention from anyone.

No technical savvy needed - and you only need 4 options (assuming the users are competent to choose between All Data/Mon-Thurs/Mon-Fri/Weekend),

Example attached - New tab called 'Job Filters'.

Perhaps its a bit deeper than I have explained. I have attached a sample page from my current master sheet.
All of the data shown in this example would need to automatically print 1 copy for each day the job runs in that week. This is why I was attempting to use sheets and each sheet would have the job on it if the job ran that day.
I could go through and add the job to the sheets it needs to be on manually but then when a new job is added I would have to manually add it as well. This example is just random data but it would give you an idea of how our sheets run.

Perhaps its a bit deeper than I have explained

It is.

I'm not sure of the best way to approach this (time constraints mostly) but your "Everyday", "Every Day (Incl Holidays)", "Sun-Thur", "Mon", "Tue-Fri" system, while easy to read, does not lend itself to automation. Not saying it can't be done, just that it'll take more time than what I have available.

The other issue is "Every Day" & "Every Day (Incl Holidays)" - You need a holiday table somewhere to list those dates that are holidays.