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...