Hi,
I have been working in VBA to create a macro (button) to automatically print a summary page for each student in my class. I have copied a MS macro from a template but cannot modify to suit my needs.
My workbook has multiple sheets - attendance, homework, assessment tasks etc. I have created a 'Print Summary' sheet and formatted ready to print/save to pdf and distribute. This 'Print Summary' sheet has a drop down list (of students) and automatically populates the sheet with data from the other relevant sheets when a specific student is selected.
I would like to create a macro to automatically 'Print Summary' page to .pdf of each student as a single file. Ideally, the macro would save the files as:
SURNAME GIVEN NAME (cell C9 and E9)
in a folder TOPIC (cell D11)
eg E:\User\Folder\TOPIC\SURNAME GIVEN NAME.pdf
Many thanks
I have been working in VBA to create a macro (button) to automatically print a summary page for each student in my class. I have copied a MS macro from a template but cannot modify to suit my needs.
My workbook has multiple sheets - attendance, homework, assessment tasks etc. I have created a 'Print Summary' sheet and formatted ready to print/save to pdf and distribute. This 'Print Summary' sheet has a drop down list (of students) and automatically populates the sheet with data from the other relevant sheets when a specific student is selected.
I would like to create a macro to automatically 'Print Summary' page to .pdf of each student as a single file. Ideally, the macro would save the files as:
SURNAME GIVEN NAME (cell C9 and E9)
in a folder TOPIC (cell D11)
eg E:\User\Folder\TOPIC\SURNAME GIVEN NAME.pdf
Many thanks