Hello! I am new to vba and am trying to write a macro that will help me create reports for multiple departments. I have a slicer set up to update all of the worksheets based on that department's data. I then need to print which worksheets are applicable to the department as one pdf.

I have approximately 150 different slicer values/departments that need a report, and there are 8 different printing groups. For example, Group 1 needs Sheet A,B,C, group 2, needs sheet ABCD, Group 3 needs sheets ABD, etc. I have been focusing on having the macro look at a range of values to say if the pages should print or not due to having so many groups. I have also tried listing the groups as a case within the macro and referencing a cell to determine which sheets should be printed for that department. I can't get either to work or am only successful getting one page to print vs all applicable worksheets.

I have searched multiple forums and websites the last few days and cannot get anything to work. So far I have been focusing on getting the printing down before I started working on adding in the slicer selection.

In summary, I am looking to:
1. Print specific worksheets to one pdf for multiple groups based on the criteria they meet.
2. Select a slicer value, print, and loop through all slicer values.

Any help with either of these issues would be GREATLY appreciated!!!!