I have my recorded music collection catalogued in a worksheet where column A shows the date when a new addition to my collection is added, column B shows the sequential number identifying the recording, column C shows the name of the composer. Other columns show the names of the orchestra, performers etc. I would like to sort this worksheet in alphabetical order of composer in such a way that the whole row moves i.e the sheet would appear the same after sorting; apart from the catalogue numbers in column B which would no longer be sequential.
I would normally maintain the worksheet in this composer sorted condition but I will need to be able to revert to the original condition when I want to add a further recording and need to locate and allocate the next sequential number.

Can anyone tell me if and how this can be achieved?

Hi,

Am Sun, 8 Sep 2013 15:25:53 +0100 schrieb Quilp:

I have my recorded music collection catalogued in a worksheet where
column A shows the date when a new addition to my collection is added,
column B shows the sequential number identifying the recording, column C
shows the name of the composer. Other columns show the names of the
orchestra, performers etc. I would like to sort this worksheet in
alphabetical order of composer in such a way that the whole row moves
i.e the sheet would appear the same after sorting; apart from the
catalogue numbers in column B which would no longer be sequential.
I would normally maintain the worksheet in this composer sorted
condition but I will need to be able to revert to the original condition
when I want to add a further recording and need to locate and allocate
the next sequential number.

select one cell in your table = Data = Sort.
In the new dialog choose Sort by column C


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Thanks Claus - easy when you know how!

Having sorted part of my worksheet, thanks to Claus, I am now wondering if it is possible to individually sort sections of the sheet.
The single page sheet shows the sequential catalogue number in three groups and I have sorted the cd's section O.K. but I would now like to sort the Digital and DVD sections independently of each other and of the cd section. Is this possible or will I have to split the sheet into three pages and independently sort each page?

To clarify, I have allocated numbers 1-505 to cd's, then used the following two rows to enter a heading "Digital Music" and then started using rows 507 to 571 to list my mp3 downloads followed by a heading "DVD's" in rows 572-3 after which I have listed my DVD collection.

Hi,

Am Wed, 11 Sep 2013 19:12:21 +0100 schrieb Quilp:

To clarify, I have allocated numbers 1-505 to cd's, then used the
following two rows to enter a heading "Digital Music" and then started
using rows 507 to 571 to list my mp3 downloads followed by a heading
"DVD's" in rows 572-3 after which I have listed my DVD collection.

insert 2 empty rows between the different sections. Then you can sort
the three parts in three actions


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Thank you Claus - your help to this old newbie is much appreciated.