I am trying to create a schedule that tracks hours and locations worked over time. The employees on the schedule move locations fairly often, and I would like to be able to track what location each employee was on at a given date, as well as what employee was at a certain location on a given date. I have been struggling with this for a few days and not really made any progress, so any tips or advice would be greatly appreciated. I am including a file with what I have made so far, and it includes some more detailed notes about what I am hoping to accomplish. I am not tied down to the format or layout I have at this point, so if it needs to change in order to accomplish my goals that is completely fine. At this point I am not even sure if what I am trying to do can be done in excel or if I need to start looking at a program like Access.

Thank you for any help that can get me moving in the right direction!Schedule example.xlsx