Linking Information

[Terrill]

Hi,

I need help with a linking issue I'm having. I work with a sports team, and
I'm trying to setup a spreadsheet of all the statistics of our players. On my
summary page, the players are grouped based on their position, and when I
link each player's stats to the summary page, it works perfectly fine.
However, if we add or remove players from the first sheet, it messes up the
order, and now I have defenseman in the category for right wings, and there's
no real order unless up drap and copy each player into their specific
category. Any idea how I can link these values, and still be able to add or
delete players (rows) from my main page, and it wont affect where the players
are in my summary page?

 

[Pete_UK]

If you had another column for position, and some code in there like D
for defense, then it would not matter where on the sheet the player's
record was - you will be able to extract it based on the position
column.

Hope this helps.

Pete