Hello...I've made several attempts to write this code with no success; however, I am new and trying to teach myself VBA coding.
My goal is to create a loop that will copy/paste/export to pdf a report template for each employee of a region.
The way I envisioned this is via the following steps:
1) copy the "payroll id" field (column C of worksheet titled "Provider Listing") based on a conditional filter of the "region" field (Column B of Worksheet titled "Provider Listing".
2) paste the copied "payroll id" field into the "Report" worksheet cell B5.
3) export the resulting "Report" worksheet to pdf (with the unique "payroll id" listed in each resulting filename)
4) loop through the records for the selected region, doing the same steps 1-3 for each employee of the selected region.
If I could get help on any of these steps or the process as a whole, or advice on how to better accomplish the task, I'd be very grateful.
My sample file is too large, however, I've screenshot each worksheet for example.
Thank you in advance for any help or advice.
Provider Listing worksheet
Report worksheet
My goal is to create a loop that will copy/paste/export to pdf a report template for each employee of a region.
The way I envisioned this is via the following steps:
1) copy the "payroll id" field (column C of worksheet titled "Provider Listing") based on a conditional filter of the "region" field (Column B of Worksheet titled "Provider Listing".
2) paste the copied "payroll id" field into the "Report" worksheet cell B5.
3) export the resulting "Report" worksheet to pdf (with the unique "payroll id" listed in each resulting filename)
4) loop through the records for the selected region, doing the same steps 1-3 for each employee of the selected region.
If I could get help on any of these steps or the process as a whole, or advice on how to better accomplish the task, I'd be very grateful.
My sample file is too large, however, I've screenshot each worksheet for example.
Thank you in advance for any help or advice.
Provider Listing worksheet
Report worksheet