Hello – This bit of code does exactly what I have asked of it. That is - based on a spreadsheet in the same workbook which I have named “Print Control” which has the following: (Header Row is row 1) Column A is “Yes” or “No”, Column B is “Participants Statements”, Column C is 1,2,3…, and Column D is the participant’s name. In cell H7 is “2016 3rd Quarter”. For each “Yes” in column A the statement is generated. On the Participant Statement itself, in cell U2, when the number or value changes, the participant statement is populated with participant specific data. As you can see, as the code loops through, changes the value in U2, populates and prints.
What I would like to have happen is that when each participant statement is output it does so with the Participant’s Name and “2016 3rd Quarter”. Ideally in PDF format. I appreciate the help!
Bookmarks