Hi all,
I must start by saying I'm fairly new to excel and I have started creating a workbook with multiple sheets. Here is what I'm trying to do:
I have a list of NHL players on one sheet. I have called this sheet called Forwards. I have another sheet I have called Line Up. The Line Up sheet has a data validation list of all the forwards from the Forwards sheet. When a player is selected from the data validation list on the the My Picks sheet, I would like their name removed or even highlighted a different colour from the Forwards sheet to indicate that they have already been selected.
is this possible. I'm going nuts trying to figure this out.
Thanks for the help,
Chris
Bookmarks