This is a bit of a weird one.

I've created a layout for my student mark sheets in Excel. I've created another 'results' file which has a form for filling in the marksheet, so each student has a row and all the completable sections in the marksheet appear in a column.

I have a vague idea of how to reference one file from another and I know how to do a form....

...but what I want to do is print the marksheet document once for each entry in my seperate sheet which contains results and save all of them as PDFs.

Any idea?