So I created a time schedule spread sheet. I have multiple tabs for multiple departments. When doing a schedule for servers, I have it as a drop down. I want it so that if I have the same person selected in consecutive cells, it will pull the first cell (start time) and the last cell (end time) to a different work sheet that will put in the correct start time and end time next to the name that the other work book had. So pix one is of the "server" time schedule where the name is picked from a drop down list.Pix1.png
Pic two is the main tab that I want the "start time" and "end time" to go next to the corresponding persons name.
Pix2.png
I'll probably end up adding a "START" and "END" for the main spread sheet if need be and maybe put in two different formulas?
I was thinkin an "If" formula but I have no idea how to do that witha drop down and how to get it to pick the first and last cell in the column that I need...
or if anyone has a more simplified idea, I'm alllll ears!
Bookmarks