So, Ive made a 6-week schedule for my hospital and I need to have it generate a daily schedule.
So the nurses would have a "A" or "P" beside their name under the corresponding date. Based on the date of the last spreadsheet "housewide", I'd like excel to pull the nurses' names and populate it to the corresponding columns.
Ideas?
Bookmarks