Greetings, I have 2 worksheets, one worksheet is a supervisor's name, and the other worksheet includes scorecards for each of the supervisor's agents. On the supervisor worksheet I'm wanting to include a "Print Scorecards to PDF" button that will pop up a window asking the user which path they want to save the PDF files to. Once the user selects the path, the VBA will go to the scorecards worksheet and print each page and name them individually. So Page 1 in the print area would look at the agent's name in cell C4 and save as "[C4] - Scorecard for [C6].PDF" NOTE: Cell C6 includes a date.
Then it will repeat for Page 3 (agent's name in cell C54), Page 4 (agent's name in cell C104), etc. on that same worksheet.
Can anyone help out with the code to achieve this? Thank you in advance!
Then it will repeat for Page 3 (agent's name in cell C54), Page 4 (agent's name in cell C104), etc. on that same worksheet.
Can anyone help out with the code to achieve this? Thank you in advance!