LindsPow
New Member
- Joined
- Nov 13, 2022
- Messages
- 1
- Office Version
- 365
- 2021
- 2019
- 2016
- Platform
- Windows
Hi There,
I want to create a Macro that will select each filter in a specified column and then auto print. The info on this sheet changes every time I open it and multiple people will be using the file and I want to be able create a button and assign the Macro. I want the filter column to be column C. I have a formula in all the cells in Column C already that appear blank if no data is found on another sheet and I don't want to print the (BLANKS) filter. Any help would be greatly appreciated!
I want to create a Macro that will select each filter in a specified column and then auto print. The info on this sheet changes every time I open it and multiple people will be using the file and I want to be able create a button and assign the Macro. I want the filter column to be column C. I have a formula in all the cells in Column C already that appear blank if no data is found on another sheet and I don't want to print the (BLANKS) filter. Any help would be greatly appreciated!