Dear Excel Experts,
I hope you can help me with this Shift Template.
I would like to have a dropdown list of the Locations AN7:AN12 in the Calendar F8:AJ28 instead of having "O" and "D".
I know that I can just put the data validation to have the dropdown list, but I need the "Shift pattern" E8 to be still linked to F8:AJ28.
So when I change the date, the data will also change. Please see the attached spreadsheet. Thank you so much for your help.
Bookmarks