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
|