Hi Everyone,

In advance, thanks for reading my post.

I am going to produce lots of data in an Excel table (names, email address and answers to questions). When this Excel sheet is manually updated (when I copy the data from a program to this Excel sheet), I want excel to automatically check if column x is "yes" and column Y is "no" and if that is the case, I want Excel to create a report with data from the sheet, per row. I want that report to be saved as an PDF and be send to an email address in the same row and I want Excel to change column Y from "no" to "yes".

So, for example, I will be having 3,000 rows with data about a specific person (so 3,000 people). I want to email an automated report PDF to each person with: results in the row of that person and an average of the rows of all the persons.

Can this be done with Macro's? Or does the macro's not allow to Save as PDF's and send emails?

I am aware that my description may be a little bit vague, please ask me if you need more information.

Best regards,

Rob