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

Grouped sorting
 

Scot wrote:
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

I'll suggest using Autofilter, which works with rows, not columns.
Select your table.
Data; Filter; Autofilter.
Hit the Trans# arrow and select 'Custom'.
Show rows where Trans#
<does not equal <Trans#.
This will show only the data rows.
Data; Sort; Trans# (has header row).
Data; Filter; Autofilter to remove the filter.
Then you'll have to copy and paste special (transpose).
(This is on the sheet, not in code; should be able to do with code)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---