In Progress

Fantasy Football Draft Excell Spreadsheet

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.

Skills: Excel

See more: fantasy football spreadsheet, fantasy football spreadsheet 2014, live draft, football team, football players, Draft, d draft, check spreadsheet, player information football, pick excel, live lock screen, populate excel spreadsheet, 2014, fantasy draft excel spreadsheet, spreadsheet need track, player tab, lock screen time, live football spreadsheet, football fantasy, fantasy football live update, excel football live, auto formulas, fantasy spreadsheet, fantasy football 2012, spreadsheet players

About the Employer:
( 7 reviews ) Ellington, United States

Project ID: #4227954

Awarded to:

pierreho

Dear rickdabate, What you need can be done with some VBA code. Nevertheless it would be easiest to have all records in only one table. Please have a look on my example. Best regards

$100 USD in 5 days
(24 Reviews)
4.8

5 freelancers are bidding on average $70 for this job

ksnrajesh912

Hi please check PM

$70 USD in 10 days
(2 Reviews)
2.3
paintthesky14

Hi Rick, I have completed your project with almost changing nothing to your sheet! I assure you its very sophisticated and a fast solution. Please see PM for further details.

$80 USD in 2 days
(2 Reviews)
2.0
onlineupdatebd

I have experience in Data Entry, Data Processing, Forum Posting, Forum Software, Web Search, Data Mining, Web Scraping, and all kinds of administrative job.

$50 USD in 7 days
(0 Reviews)
0.0
kuldeepsingh2508

I am Data Entry Expert, MS Word and MS Excel. i know how to do your job and i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your More

$50 USD in 10 days
(1 Review)
0.0
bhojanapriyulu

I can deliver quality work withing a specified range of time paying close attention to detail and accuracy. Customer satisfaction and quality work are my top priorities. I am looking forward to have a mutual fruitful w More

$50 USD in 7 days
(0 Reviews)
0.0