Maybe you could use the technique at Debra Dalgleish's site:
http://contextures.com/xlForm03.html
and maybe...
http://contextures.com/xlForm02.html

ascottj wrote:

I have created a worksheet that has a place for a student's name and
teacher's name. I have another worksheet with all of the students' names and
teachers' names that need to go into the first worksheet. I would like to do
something that would work kind of like a mail merge that would create a sheet
for each student's name and teacher's name that could be quickly printed.
Any ideas?

--

Dave Peterson