Integrating information from Word to Excel (not mail merge)

[Pamo13]

I have a student who has put together an Excel spreadsheet for Fantasy Football. He has all of the player names in Word, and all of the stats in Excel. How does he get the stats from Excel into a Word document he created? There is no access to Internet for his class.

For example, if one of the guys in the FF League wanted to get the updated info on a player to see if he starts him this week or not, they want to click the players name on the word doc, and have it go to the specific rows for that player's updated stats, not the top of the first page of the document.

Any help on this would be appreciated.

TIA

 

[macropod]

Depending on how the Excel data are laid out, you could use a series of DATABASE fields in the Word document - one for each player. Insert a Heading paragraph for each payer above the corresponding DATABASE field and use a Table of Contents linked to those headings for navigation.

An example of DATABASE field usage you could adapt can be found at: https://www.msofficeforums.com/mail-merge/21847-mail-merge-into-different-coloumns.html#post67097

Whether or not the class has internet access is not a relevant consideration.