Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 296
  • Last Modified:

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?
0
morinia
Asked:
morinia
  • 2
1 Solution
 
Martin LissRetired ProgrammerCommented:
Dim ws As Worksheet

For Each ws in Worksheets
    ' Do your thing
Next

Open in new window

0
 
Martin LissRetired ProgrammerCommented:
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".
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now