Thread: Sorting
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Unger Dave Unger is offline
external usenet poster
 
Posts: 153
Default Sorting

Hi David,

I'm probably not making myself clear.

I am doing all my sorting with VBA macros, and it all works fine, I can
sort the whole list by name, or by index. When I say sorting by index,
I mean sort the index columns, right to left, that's a "normal" sort.
What I'm trying to achieve as well, is to come up with a sort that
group's all the siblings together.

The only way I've been able to do that is shift all the index to the
right, and then sort.

e.g. take 6 7 3 2 1 0 0 0 and make it 0 0 0 6 7 3 2 1, then sort right
to left, as before.

I'll give your routine a try and let you know the results. Thanks a
lot for now, appreciate your time.

regards,

DaveU