View Single Post
  #2   Report Post  
Max
 
Posts: n/a
Default

Try on a duplicate copy of your sheet:

Assuming your lists are in cols A and B,
data from row2 down, viz.:

Artist Title
ABC Text1
XYZ Text2
DEF Text3
etc

Select cols A and B

Click Data Sort

Check "Header row" under "My list has"

Ensure settings
under "Sort by" a Artist Ascending

Click OK

For the sample data above, you'll get:

Artist Title
ABC Text1
DEF Text3
XYZ Text2

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"john smith" wrote in message
...
I just created an excel catalog for my cd jukebox as I loaded the tray

(300
discs). Now I want to alphabetize column A (artist) and have column B
(album title) follow column A. Is there a way to do this?

Thanks for all help.
beo