Developing a Sorting Macro

[joker25]

Hello All,

I am having an issue building a macro that will allow me to chronologically arrange these ranges by season. The sort function does not work here so I was wondering if anyone had input on how to do this not for this document but for a variety of sheets within a workbook and all different placements on the sheet.

Thanks! Attached is an example of the work book with a few work sheets.

[Leith Ross]

Hello joker25,

It does not look like you have included any before and after examples of the sort. Which sheets will the sort apply to?

[joker25]

My apologies looks like this one was already manually sorted. Here's an example of a before and after.

[Leith Ross]

Hello joker25,

Thanks for the updated workbook. It makes perfect sense now. Excel and VBA sort text by the character codes which is fine for letters but numbers don't sort according to human logic. As long as each sheets layout is the same as what you posted, I can create a macro to run on any sheet in this format.

[joker25]

That's great news! Yes the pages are layed out the same but the number of rows per season will vary.

I appreciate your help Leith

[Leith Ross]

Hello joker25,

Excel always seems to act erratically or crash at the worst possible time. The attached workbook has a button on it to run the macro. The macro gathers data from the "Before" sheet and then copies the sorted ranges over to the "After" worksheet.

Unfortunately, I can not do a sort in place. The macro could be modified to use a single destination sheet for the sorted ranges and copy the sorted ranges back to the original sheet. That is, if you need to sort in place.

[jindon]

No use of extra sheet.
Try the attached.

[joker25]

Can these sorts be applied to the entire workbook for multiple sheets or only the one sheet?

[vnzerem]

@ Jindon...your code is very well written

[jindon]

@ Jindon...your code is very well written

Thanks...........

[vnzerem]

@Jindon...in your code, can you explain to me the lines in red? I will like to fully understand your reasons especially the "CreateObject(System.collections)" Thanks

Please Login or Register  to view this content.

[FDibbins]

@ Jindon, in case you were worried about vnzerem's asking question's on another member's thread, if they are just asking for explanation of code/formula or formula that has been provided, I think it would be OK to explain.

If it develops into asking for chamges, then a new thread would be required

[jindon]

Thanks.
vnzerem has opened a new thread already, so I replied to his/her thread.