sm1308
08-14-2008, 01:42 PM
Hello All,
I apologize if a solution has been posted already on the site, I have not been able to find it yet!
I would appreciate any help on the following:
I am looking to automate report generation in excel. I have a workbook with a worksheet that is the "report" which pulls in data (from a data sheet in the same workbook) based on the entry (unique key) in cell a1 in report sheet (the vlookups populate the report each time an entry is made in cell a1).
For each of the possible values for cell a1 (there are 200) I would like to generate a report and have this saved in a specified directory as excel (or pdf). For example let's say i'm generating report cards for a class of 200 and I have the raw data in a file and want to automate the generation of a "report" for each student. Each file will be distributed independently.
I do have a list of the cell values that should be used to generate the reports.
For the time being I am simply changing the value in the cell manually and copying --> paste special values into a new workbook.
Does anyone have any ideas?
Thanks in advance for your help.
I apologize if a solution has been posted already on the site, I have not been able to find it yet!
I would appreciate any help on the following:
I am looking to automate report generation in excel. I have a workbook with a worksheet that is the "report" which pulls in data (from a data sheet in the same workbook) based on the entry (unique key) in cell a1 in report sheet (the vlookups populate the report each time an entry is made in cell a1).
For each of the possible values for cell a1 (there are 200) I would like to generate a report and have this saved in a specified directory as excel (or pdf). For example let's say i'm generating report cards for a class of 200 and I have the raw data in a file and want to automate the generation of a "report" for each student. Each file will be distributed independently.
I do have a list of the cell values that should be used to generate the reports.
For the time being I am simply changing the value in the cell manually and copying --> paste special values into a new workbook.
Does anyone have any ideas?
Thanks in advance for your help.