I have created a macro to go to 5 worksheets and update filters on each sheet. I did this via recording mouse clicks. As I expected, when I run the macro it jumps to each worksheet and back to a cell on my starting worksheet.
Is there a way to set this up to updated the filters without having to jump to each worksheet? Can I suppress the worksheets from being displayed and update the filters without actually seeing this on screen?
Is there a way to set this up to updated the filters without having to jump to each worksheet? Can I suppress the worksheets from being displayed and update the filters without actually seeing this on screen?