Thread: Sorting columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chesjak
 
Posts: n/a
Default Sorting columns

Hi
using Excel xp

I have a worksheet with names in one column and address in another column etc.

I want to be able to sort the worksheet so that I can have the names in
descending order but also have the other columns re-aranged as well ie each
line is a name and address etc. when I sort the NAME column in ascending
order, I want tle whole line to be sorted.

At the moment, if I sort the NAME column only that column is sorted and
therefore each name and address line does not stay together.

Hope this makes sense.

Any help wiould be apreciated.

Regards