How can i get excel to return a list of who is on a day off on a particular day ?
I have 52 sheets and want to create a summary sheet, so when i change the Sheet name in cell C1 on my summary page, it returns a list of who was off on a particular day, for that particular week.
Your help would be invaluable and very much appreciated. TIA
Bookmarks