Sort on 1 tab apply to all tabs

Occasional Visitor

I have a customer data base with multiple tabs. Each tab contains the status of the customer. On the master tab I want to sort by customer status and have the other tabs sort as well. 

1 Reply


You could create a macro that loops through the worksheets and sorts each in turn.

You can assign this macro to a command button and/or a custom keyboard shortcut.