Not really knowing what I'm doing, I put together this macro to sort worksheets:
If I have worksheets for example in which the value in B4 is 11-4, 10-2, 3-7, 3-2, 1-9, 1-2, it sorts them as 3-7, 3-2, 11-4, 10-2, 1-9, 1-2 when running the above macro. Close, but not quite there.Please Login or Register to view this content.
Cell B4, while meant to be a date, is not formatted as a date, and I don't want to mess with that because I've got everything else working smoothly in my own fumbling way. Is there any way to amend the above code so that it recognizes that 11-1 and 10-2 come before the other referenced worksheets? Obviously, I will eventually end up with many more worksheets ... this is just a small example.
Thanks in advance for your assistance.
Bookmarks