Hey everyone,
I am having a problem sorting a column of data which i would like to use for a macro.
What i have is a column of numbers which are all 4 digits and range from 1000 to 9000. What i would like to do is be able to sort them by ranges of 1000-1999, 2000-2999 etc. so that i can select them on the drop down sort menu like year dates (2008, 2009 etc.).
So instead of having the sort option of 1100, 1200, 1300 i would like it to be broken down into 1000 in which 1100, 1200, 1300 are sub sort selections.
http://img29.imageshack.us/img29/5959/69185703.png
Here is an example of what i mean.
Thanks in advance,
Bookmarks