Macgyver01
New Member
- Joined
- Feb 9, 2010
- Messages
- 2
I have an Excel file with multiple worksheets that each have an autofilter applied to the same set of data. The filtered cells are pulling from data on another worksheet that I need to update regularly and have the worksheets with filters recalculate or reapply accordingly. Right now the quickest way I have found to update all these filters is to either use the "reapply" button on the filter menu, or the shortcut of "Ctrl, Alt, L" after individually selecting each worksheet. CAN SOMEONE PLEASE HELP ME CREATE A SHORTCUT TO REAPPLY THE FILTER TO ALL WORKSHEETS AT THE SAME TIME?? Thanks in advance!!!