I have a spreadsheet that has dates in the first row starting in cell B1. (B1=1 Jan, C1=2 Jan, etc.)
I have the shifts and names of individuals in the first column starting in cell A2. (A2=Morning, A3=Justin, A4=Matt, A5=Afternoon, A6=Jacob, etc.)
The cells between names and dates have notes, such as appointments and training etc. (So C3 would have an appt for Justin, etc.)
Now I'd like to make a separate workbook for me to view that only shows a 2 week forecast. It needs to be dynamic as individuals move shifts. Is there a way to make it so my 2 week forecast workbook references the schedule and only shows me the next 2 weeks?
I'm not a novice, but this has me stumped.
Bookmarks