Sort worksheets by date (MMM YYYY)

I have several worksheets labelled in the mmm yyyy format and this is an ever expanding project, with macros creating new sheets in the distant future, but the creation of these sheets puts the order out of sync.

Is there any way to sort worksheets that have this format mmm yyyy, I can see plenty of macros for alphabetical sorting but not this way.

hi nickmax1, please check attachment, option to make such sorting. As you have not provided any sample file of yours it may some tweaking for a different file.

As per usual you pull through, how would you amend the code if you had two worksheets called "Graphs" and "Start" that would not be included in your sorting?

Or failing that, what would my "Graphs" and "Start" be renamed to to ensure they are always the tab to the far right (as opposed to the far left)

please check attachment

wow it works perfectly....i have been a massive pain in your backside already but any chance you could explain how your code works? Specifically how you got "graphs" and "start" to stay to the left.
IE if i wanted them to the far right of my worksheets how would i change things>?

Graphs and Start sheets to the far right position, please check attachment (assuming it should be Graphs, Start, ...)

The code takes all sheet names except Start and Graphs, creates new sheet, pastes data their in number format and text format, does sorting by the first column in numbering format, takes sorted text values and repositions the sheets.

This line allows to omit Graphs and Start sheets:

Please Login or Register  to view this content.

Details are available in VB help file, search string: InStr

Awesome - solved - thanks!

i need to sort worksheets by the following date format dd.mm.yy. How can i tweak the macro to sort by this format?

Also, if after sorting, i have inadvertently moved worksheets around and need to re-sort them, how do I action this?

thanks - will do.