G
Guest
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
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