Hello,
I'm working with the schedule on Sheet1. I now need to also use the sheet2. Sheet1 is constantly changing. I need Sheet2 to update accordingly... I could use a 'this cell equals this cell' method but the assignments between John, Bob, and Dave change from week to week... Should I use something like a HLookup?
(see attachment) Thanks!
Bookmarks