Microsoft Office Excel Automation

Question

I have an excel file where two sheets are there. First sheet is Summary. On Summary sheet some name wise data is there. I have created a report for one of the names on the the second sheet called Statement. I want to multi selection name basis the multi selection format either excel or pdf report to generate separately with the file name as the same name of the person like the report i created and saved in the same folder.

Answer 1

Hi,

May I suggest use a simple VBA macro in Excel to automatically create separate PDF files for every item in a list. The macro changes the key cell that updates the report (like a Student ID), loops through each value in your list, refreshes the report, and exports a PDF for each one.

 

Just customize:

the cell that updates the report,

the start of your list, and

the folder/filename pattern for saving PDFs.

Once set up, click the assigned button and Excel instantly generates all PDFs fast and hands‑free.

I hope this helps!