I really appreciate everyone's help with this project :-). Now that I have done some more work, I realize that I probably need to have the list of names already in place on a separate Alpha worksheet and then pull the schedule for each name. There will be 400 or more people on the schedule, and this will make it easier to find if someone is accidentally left off the schedule. I also forgot about the column for the position. I have attached a new sample. The idea would be to have the code use the names in Column A on the Alpha worksheet and pull the related schedule with the time/position/court.
Black 08:00/R1/Court 6 09:00/R1/Court 6 10:00/R1/Court 6
Thanks!
AlphaTest2.xlsx
Bookmarks