Need Excel 2 set up a scheduling program for a multitude of agents.?
In column A, a list of names from row 1 to row x. B1 to to F1 are the days of the week, Mon - Fri. List of names can and will change as players are added or deleted. For example: Using David, Don, Joel, Jim, Lisa, A2 through A6. in B2, if I type in Joel, in cell B4, I want the name from A2 , David, to appear. .
Mon Tue Wed Thur Fri
David Joel Lisa