Sorting worksheets by specific order

[DMP84]

Hello all,

I have the following problem, each month I receive a file with about 87 worksheets and they are not arranged in any order. Each month I have to sort the tabs in a specific order as they need to be sorted by region. Is there a way to have a macro sort them automatically. The tab names are always the same and it's not by alpha. For example when the file comes in the order is Huntsville, Kent, Delano, Union, Bristol, but the correct order needs to be Bristol, Union, Huntsville, Kent, Delano and I do this manually each month. The order is always the same. Is there a way to automate this?

Any help is greatly appreciated.

Thank you.

[judgeh59]

there are a bunch of ways to move WS around. And since you are not asking to put them in Alpha order or numeric order, this might work...it's labor intensive at the beginning because you have to setup each WS, but then you are done...you can add it to your personal.XSLB or create as an add-in...

Please Login or Register  to view this content.

just change the names of the sheets and change the order of where you want them....HTH

[MarvinP]

Hi DMP,

JudgeH above is correct but because you always get them in the same order you can try this.

Turn on your Macro Recorder and sort them like you want. Then turn it off and save the macro. Get the workbook again and run the macro. It will look a lot like his macro above but should have the correct sheet names. I think you can figure out what it is doing and modify the macro to fit your needs. You might not need to change anything from the recorded macro.

Read: http://www.excel-easy.com/vba/create-a-macro.html to insure you show the Developer Tab.
Also Read http://www.exceldemy.com/how-to-crea...acro-recorder/ for another example.

[judgeh59]

Actually that was how I did it....thanks MP

[Kenneth Hobson]

Please Login or Register  to view this content.

[DMP84]

Awesome will definitely give this a try when I get the next file.

Thank you all greatly appreciate it.

[judgeh59]

Glad we could all help....

If this has been completed to your satisfaction, please set the thread to Solved...If you feel we deserve an increase in our reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be us...just a thought...