Thread: Grouped sorting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scott scott is offline
external usenet poster
 
Posts: 577
Default Grouped sorting

Hello
I have data grouped in 3 columns across my sheet. I would like to sort
these groups by the first cell in each group. Due to line wrap the example
is column wise but my sheet the data is row wise

Trans# Amount RepID
123 500 JD
Trans# Amount RepID
425 300 SP
Trans# Amount RepID
256 250 AR

Sorted....

Trans# Amount RepID
123 500 JD
Trans# Amount RepID
256 250 AR
Trans# Amount RepID
425 300 SP

Thanks for all replies

Scott