Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking Excell Spreadsheets and Resorting Data
Im using Excell for my Fantasy Football Draft, Id like to have one
spreadsheet with my players in order by Rank and the other by Name, however id like to link them so that when a player is drafted i can mark them as drafted and that particular player will be marked as drafted in both spreadsheets- ive sucessfully used the Paste Special function to link the 2 spreadsheets, but i run into a problem when i re-sort the second sheet because this messes up the links, please help!!! |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking Excell Spreadsheets and Resorting Data
Try posting this in the Excel group and you may have better luck.
" wrote: Im using Excell for my Fantasy Football Draft, Id like to have one spreadsheet with my players in order by Rank and the other by Name, however id like to link them so that when a player is drafted i can mark them as drafted and that particular player will be marked as drafted in both spreadsheets- ive sucessfully used the Paste Special function to link the 2 spreadsheets, but i run into a problem when i re-sort the second sheet because this messes up the links, please help!!! |