What I'm trying to do is outlined in the "Need Help Here" work sheet.

It's not real clear what you want to do.

Do you want to extract data from the other sheets for each of the
participants?

C4 = Mike Tadlock
C5 = 2006
C6:Cn = list all the picks Mike made for 2006 ?
C13 = 2007
C14:Cn = list all picks Mike made for 2007 ?

What's the procedure as far numbers of players picked and how many of each
type of player can be picked?

This will be very complicated to achieve!

Biff

"altopalo" wrote in
message ...

Hi,

I really could use some help.

I've got one work book with 4 work sheets devoted to various positions
(e.g. QB RB WR/TE & K). Each of these worksheets lists specific
players, their NFL team, Fantasy Team, Salary, Owner, and several other
data parameters.

I've attached the .xls in question.

What I'm trying to do is outlined in the "Need Help Here" work sheet.

Thanks very much for any help you can provide.

Mike


+-------------------------------------------------------------------+
|Filename: 2006draft1.4.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4734 |
+-------------------------------------------------------------------+

--
altopalo
------------------------------------------------------------------------
altopalo's Profile:
http://www.excelforum.com/member.php...o&userid=25276
View this thread: http://www.excelforum.com/showthread...hreadid=539703