Hi there, I've seen variations of this problem on this site (like here) as well as others, but I'm pretty much brand new to VBA so I'm struggling to fit other examples to my specific use case. The Excel Workbook I'm using has 9 tabs, 3 of which are data dump only tabs that, when filtered, generate the results on the other 6 tabs. The filter criteria is the same on each of the 3 tabs, in this case I'm using names. The process is like this:
1. Filter Swanson, Ron on the 3 data dump tabs (name to be filtered is located in same column on each tab)
2. Highlight the other 6 tabs
3. Save as a PDF with password protection and page numbers
4. Repeat with new name
This seems a bit tricky, especially because I'd like the PDF outputs to be password protected and have page numbers. How can I have a macro that filters a name on 3 tabs and saves down the filtered result as a PDF with a password and page number? Any guidance is helpful. Thank you.