sorting linked columns?

[Mr. Newt]

I have columns of data that I would like to sort. The only problem is if I
sort one column, the associated rows in the adjoining columns do not sort
with it. Is there a way to link rows of data so that when a column is
sorted the rows are sorted with the column?

Thanks.

Robert

 

[Roger Govier]

Hi

Mark the whole range of your data before performing the sort choosing
your column as the first sort column.
that way, all the other columns adjust with the chosen column.

 

[Mr. Newt]

Thank you. That worked just fine. =)

Robert

Hi

Mark the whole range of your data before performing the sort choosing your
column as the first sort column.
that way, all the other columns adjust with the chosen column.