Hi All.

I've inherited an employee weekly schedule done in Excel. I'm researching other options for the future but for now I've got to work with what I've got.

Here is one of the 9 tabs representing a location and the shifts at that location. Employees often work multiple shifts and multiple locations.

I want a 10th tab that will list all employees, with their location and shift under the days that they work - like the other tab that I named "all locations".

I know I'll have to change the way each shift at each location is shown but I'm not seeing the best way to do it.

To make matters worse, I need each location with all of it's shifts printable on one page like it is now, so it can be distributed to multiple people who do not have access to the file.

Can this elephant be eaten?

Thanks!

There is a consolidate function in excel which might be used if each tab is organised in the same way

otherwise you construct your summary by referencing the data in each tab

you do this by placing your cursor in a cell, type =, then point to the cell in another tab where the data is located
. You can select groups of cells ( a range) to be reproduced on another sheet and use if statements to select specific data.

You should seriously look at why you need everyone to have access to the data and yet not allow access to the individual tab. It is possible to lock cells and sheets so they are read only and to print PDF copies of the sheets

all elephants are eaten one bite at a time

Think about organising the data differently with the employees listed in column 1

remember that if it is organised properly excel can be used as a database to do this you will need fields; employee, shift, day or date, hours, location. This will enable you to use the inquiry functions of a database