I'm trying to prepare for the draft and wanted to see if there is an easy way to do this.
I have 4 sheets:
1. Player Projections
2. Overall ranking
3. Tier ranking
4. Draft tracker
Basically, when I enter a player's name in the Draft Tracker which shows all the teams by round, pick, I want that player's name deleted from all the other sheets. Last year I linked the names from each sheet so that when I deleted a name from Sheet 3, it would be deleted from all the other sheets. But I had to enter the name in Sheet 4 and delete the name from Sheet 3 in order to make this work. Very tedious.
Last edited by Yoda on Sat Mar 21, 2009 4:42 pm, edited 7 times in total.
"Think of how stupid the average person is, and realize half of them are stupider than that." ~George Carlin