merging workbooks

[Guest]

I am a teacher. I have to enter all my students grades into a form, I then
have to merge that document with the report template in order to quickly
print all the reports for my students without having to enter all the details
on each individual report.

How do I do this?

Thanx
Ria

 

[Bryan Hessey]

This sounds like a job for MS Word's 'mail merge' (or Form Letter), for
which Excel has a Help under 'Mail Merge'

 

[Dave Peterson]

And just some references...

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.