I'm not sure if it's possible, but maybe you could have a helper column (hidden
if you don't want to see it) that contains the real sort order.

An =vlookup() formula that translates the "visible" value into its "hidden"
version.

Value SortValue
abcd 30
aaaa 20
bbbb 40
zzzz 10

=vlookup(a2,hiddensheetname!$a:$b,2,false)

And you could build you own custom list to sort on.



"Scottmk <" wrote:

Dave, that code worked perfect! Thanks, and I see what you are saying
about not having spaces, but I needed them (I thinK). You see, I
wanted the first column to stay in a particular order...those were the
groups....and I didn't want them to be alphabetically, so I think that
is how I had to do it...
Thanks again,
Scott

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson