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,