Fantasy Football Draft

[x65140]

I'm an excel rookie, and just know the basics...I don't know if this i
possible or not - I've attached a cut-down version of my spreadsheet t
meet the size restriction.

This sample contains two pages. The first page is the Draft Pag
-(Draft Number, Fantasy Team Name, Position, Player Name, Salary). Th
second worksheet is a ROSTER sheet. It contains the rosters for
teams (QBs,RBs,WRs,TEs,PKs,DFs).

What I am trying to do is: When I key in the information on the draf
sheet, I want it to populate the roster sheet for the appropriate team
in the next available slot for that position.

For example if my DRAFT sheet looks like this:
BEE-RB-TRAVIS HENRY-30
ROT-WR-RANDY MOSS-55
BEE-QB-BRETT FAVRE-50
ROT-RB-DEUCE MCALLISTER-60
BEE-QB-TOM BRADY-40

My roster sheet should be:
BEE
QB BRETT FAVRE 50
QB TOM BRADY 40
RB TRAVIS HENRY 30

ROT
RB DEUCE MCALLISTER 60
WR RANDY MOSS 55

Any help would be greatly appreciated! Thanks

Attachment filename: football.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=59337

 

[Dave Peterson]

First, I don't think I'd do this.

I'd keep all my data in one worksheet. The I'd apply Data|filter|autofilter to
show/hide any subset of my data.

But if you must, you may want to take a look at how Debra Dalgleish does it via
code:

Deb's site:
http://www.contextures.com/excelfiles.html

Look for:

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- creates a list of unique items,
creates a sheet for each item, then replaces old data with current.
AdvFilterCity.xls 46 kb

and

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm