Forum Discussion
Solved
Help referencing a cell from a different sheet
Hello, I have a master sheet with the schedule for all of my employees and am trying to make a sheet with individual employee's schedules. My idea is that the Sheet for each employee will reference the Master sheet. I am using this formula below but am unable to figure this out.
=Sheet2!B2
In my case i'm tying =Schedule!A9 but it is not working.
Any and all help would be appreciated!
Thank you in advanced!
mathetes Thank you for your help!
https://1drv.ms/x/s!AgWnVeQ6FtUXgnUUBrAJAc-LgLsk?e=raAZid
Here is a link, please let me know if that works.
Thank you again for taking some time to help!
Now that I can see what you're working with, I have one observation (possibly more to follow) and more questions.
The observation: Your master sheet is designed for human viewing. Such a design actually interferes with robust Excel functioning. In particular, too many empty rows, and merged cells. A good excel set of "raw data" or, if you prefer, "master data," should be simple rows and columns of data, no blank rows or columns, no merged cells (your column N and all of rows 5 and 6). All of those blanks and merges make a sheet "look nice" to the human eye, but are (sorry to have to say it) a bad practice for good Excel. Especially given that this is mostly for "behind the scenes" data, don't waste time and energy making it look pretty.
That said, it's not altogether clear which data you are wanting on the "Supervisor" sheet: do you want the hours of the supervisor OR the of one of the employees that is going to be supervised by a given supervisor? If the former, there should be designations like "Supervisor A" and "Supervisor B" just as you in this demo sheet have Employees A, B, C etc. If the latter, then we'll need to know which employee.
So I've done a very basic formula to get the data for the first supervisor into the first several cells--that formula can be copied across to fill in the rest of the row.
But my longer term preference would be to help you design a spreadsheet so that all you'd need to do is enter the name of one of the employees and the entire four weeks' schedules for that employee would appear in your "Supervisor" Tab. That will require an extensive (but straightforward) modification to your "master" sheet. Are you willing to do that?
