Sjajtner
New Member
- Joined
- Feb 5, 2021
- Messages
- 1
- Office Version
- 365
- 2019
- 2016
- 2013
- Platform
- Windows
- Mobile
- Web
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!!!!
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!!!!