I have a spreedsheet that provides me with data that includes employee names, employee numbers, dates he/she worked and a coded shift.
I want to take the dates that are provided and have the shift codes appear under the appropriate date in a horizontal calendar. I've been trying to use a vLookup formula, but it's not working the way I had hoped.
I've attached a sample sheet with the infomation as I get it and two calendars. One calendar has my failed vLookup formula and the other is the way that I want the data to appear.
It's importat to note that there are 2 shifts on the form (and possibly more in the future) and each employee can work up to 2 shifts in any one day. The shifts are AS1 and AR1. The AS1 shift is more important and I would like to see it represented on the calendar first.
Any help would be appreciated.
Also, if a macro would be a better option, I'll need help with that too.
Bookmarks