Hello,
I receive a rather large amount of data from an external source that I need to reformat and distribute to students. I've created a macro to generate a pivot table and insert headings and page breaks. What I'm struggling with is adding the student name to each sheet and ideally a page number that resets for each student. In this example, I am hoping to have the student's name (Student 1) on each subsequent page. It could be part of the header or on the top of the text. I've tried a few things without success.
Please pardon my text overlap. That is fixed on the actual document.
Thanks in advance for your time and expertise!
Bonnie
I receive a rather large amount of data from an external source that I need to reformat and distribute to students. I've created a macro to generate a pivot table and insert headings and page breaks. What I'm struggling with is adding the student name to each sheet and ideally a page number that resets for each student. In this example, I am hoping to have the student's name (Student 1) on each subsequent page. It could be part of the header or on the top of the text. I've tried a few things without success.
Please pardon my text overlap. That is fixed on the actual document.
Thanks in advance for your time and expertise!
Bonnie
