Fantasy Football Draft Excell Spreadsheet

IN PROGRESS
Bids
6
Avg Bid (USD)
$67
Project Budget (USD)
$50 - $100

Project Description:
I'm looking to get this spreadsheet ready for the 2013 - 2014 season.
This will be used by me to track my fantasy football draft while it's happening. As players are picked, I need to track who has been taken, and who I have available to pick from.
There are tabs for each position an their rankings, (I've imputed 2012 information here, but I will update this when the time comes). The main purpose is to track my team, and what players have been taken, an who is available to pick from. I'm trying to make the main page called, "Live Draft" auto populate all of this for me.

On the main page I'd like to search for a player that was just picked, click submit (or something), then, this player would be crossed out and taken out of the search for availability. On this main screen I'd like to display the next top 3 players of each position, (This would be changing as players are picked). When searching an submitting a player, I'd like there to be a check box or something, indicating this this is for my team. Once checked, the "My Team" tab would auto populate with who I just picked. I'd also like a way to reset the spreadsheet once done.

I'd also like to lock all the cells with formulas in them so I don't ruin any calculations.

Additional Project Description:
02/09/2013 at 10:18 EST
I added the template that I started that will hopefully explain what I'm looking for. Hopefully it uploaded.

Skills required:
Excel
Additional Files: My2013Draft+Template.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 100
in 5 days
Hire ksnrajesh912
$ 70
in 10 days
Hire paintthesky14
$ 80
in 2 days
$ 50
in 7 days
Hire kuldeepsingh2508
$ 50
in 10 days
$ 50
in 7 days