Generate Narrative Report from Summary Score Table

[Darko_Giac]

Hi all,

I'm not sure whether this is the correct forum to be posting in, but I'm looking to create a comprehensive narrative report from values that would be entered in a separate table.

There are sections of the report I'm looking to create that would always be the same. However, what I would like to change in that narrative are: student scores, student name, and student gender.

I've attached a sample excel file of what I am looking to accomplish. In short, I have one table (Table ), which would include a summary of scores for a test for a particular student. I'm looking to create a button that would generate a narrative based on those values, as well as fill in the name of the student whose pronoun would change based on their gender (both the "student name" and "gender" fields are found under Table 1).

For instance, if I enter the student name as "Mike" and gender as "Male" and click a "generate report" button, it would fill in those values throughout the report.

I'm assuming this would be done through VBA, but not sure exactly where/how to kick off this process.

Any pieces of advice/suggestions are greatly appreciated.

Darko

[Sintek]

This will give you an idea...Build your string and populate Shape after...

Please Login or Register  to view this content.

[Darko_Giac]

This will give you an idea...Build your string and populate Shape after...

Please Login or Register  to view this content.

Thanks very much for you help! This worked well. I definitely have a strong staring point.

Darko

[Sintek]

Glad I could contribute...Tx for rep +