Linking Information
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? |
Linking Information
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? |
All times are GMT +1. The time now is 11:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com