sort data and move it to diferent sheets

'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column. You can use the column with your Dates I suppose.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing. In this base macro the sheets are named for the values in the vCol you select to use in the macro.


There is a sample sheet there where you can test this out.

It's a purely alphabetical sorting as is all text sorting. In the US the common date format is mm/dd/yy which means for us it sorts "correctly" even alphabetically since sorting by months then days is what we want, and sounds like what you want as well.

In my opinion the most perfect simple date format is actually: yyyy.mm.dd

As long as your local or desired default date format is dd.mm.yy your always going to be going the long way around the block to deal with it.

I suppose you could add quite a bit of complexity:

1) Temporarily change all the existing sheet tab date formats to mm.dd.yy
2) Format the vCol in the macro to that same format
3) Run the macro to parse the data and create sheets as needed
4) Change the formatting of that vCol on all sheets and the tab names back to your desired dd.mm.yy format.