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?

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

On Apr 18, 8:07*pm, Terrill wrote:
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?