Thread: Sorting rows
View Single Post
  #11   Report Post  
Old September 13th 13, 02:04 PM
Quilp Quilp is offline
Junior Member
 
First recorded activity by ExcelBanter: Aug 2013
Posts: 27
Default

Quote:
Originally Posted by Claus Busch View Post
Hi,



in which column are your numbers? You have to modify the references to
your sheet.



I have now made it possible to find quickly the highest number in my
cataloguing sequence by inserting an extra column, now column A, and
entering sequential numbers into it. However, this seems a clumsy way
to do it.


Another way is to insert a new column with your medium, e.g. CD, DVD.
Then you can put your tables together to one table, you can sort first
by medium and then by composer and if you want enter new data you can
sort by number, and so on.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
The numbers, now out of sequence, are in column B