How do I automatically cross off (strike through) an item from the original list after it has been selected from a drop down?
I have a sheet for each position (i.e. "1B", "2B", "3B", "OF", etc.) which has player names and stats and are all formatted the same. I have an additional sheet called 'All Rosters' - that has all 12 teams and their roster. For each position under each team there is a dropdown menu to choose from. I can't figure out how once the player is selected from the dropdown that is simultaneously crosses off the name from the original list.
I am new to using excel formulas and even less experienced with macros and VBA. I am willing to learn though! Any help is greatly appreciated.
Bookmarks