Sorting becomming redundant! Please help.

[Lancefer]

I have built an Excel spreadsheet with the following:

A B C D E
Song Song Moke Peak Lyrics
Year Rank Rank Position (Commented)



F G H I J
Have Artist Artist Title Time
Have F-L L-F
not


K L M N O
Type Written Date Other Data
by entered
charts

The Spreadsheet has 27,436 Entries to date, I am continuously adding
data, but to add it properly and easily I have to sort by:
Artist/Title,
Title/Year,
Lyrics/Year,
Song Year/Rank

Over - and - over again...ugg
Is there a macro that can sort my list with a single click?

BTW, I know it would be easier to do this in Access, but it needs be
be easily opened and viewed by amatures that have trouble with
notepad.

Please cc: to (e-mail address removed)

 

[David McRitchie]

Hi Lance,
Sort the most minor columns first
then the next more major columns, etc.

Record a macro while doing the above and you have your
macro.