Auction Style Draft
 

Have a Fantasy Footbal draft.Starters are auctioned & reserves are drafted
in order of previous year finish. Looking to create spreadsheet which lists
players in order of when auctioned & then a second spreadsheet that
extrapulates that info & lists the players by drafted team.Have a workbook
made up of 2 sheets. First sheet Team By team list of players, player draft
position, player cost, player position. Second sheet is the actual auction
style draft which has the same info but is in draft position order. How can
can i extract the info from the second sheet & put it in its proper place on
the first sheet. any help would be appreciated greatly. been battling for
quite sometime now