Link to home
Create AccountLog in
Avatar of morinia
moriniaFlag for United States of America

asked on

Using same custom sort on multiple tabs within same spreadsheet - Excel 2010

Experts,

I have a spreadsheet that has 10 tabs with the same data.  Each tab is representative of an enrollment month.

I would like to sort each tab the same way.  Is there a way to do this without doing a custom sort on each tab separately?
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
The above would be put in a macro and the "do your thing" part could be a macro recorded while you sort one page and then generalized to replace the specific sheet name with "ws".