Let me first start off by saying hello. I am a long time browser of this board and today I registered.
I have an excel spreadsheet with student ID numbers and scores for various tests. I have looked at the microsoft templates as well as done an extensive search here and I have not been able to figure this out.
I want to create a button (or some type of function) in the excel file that will export the student ID and several of the test scores which are in the same row into a word document I have created. I would like to be able to select any student or students and then press the button to fill in the word template with their information and save it as a new document with the student ID as the name.
I do not know how to set this up.
I use excel almost every day but I have very little experience with macros.
Any help as to which direction to head with this would be much appreciated.

-Chad