link columns to sort all together

[bkunes]

i have 10 columns of data all coresponding by row. I want to sort these
columns all together so that the corresponding data stays together. However,
i do not want to have to manually click sort every time my data updates. can
anyone help i really need help im a co-op student and need to get this done
quick

Thanks
--

 

[RagDyeR]

This is your 3rd post on the same subject.

You can answer the question I asked in the first one using your latest post.

Not a good idea to start more then one.

Responders may waste time duplicating answers already offered in the other
posts.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

i have 10 columns of data all coresponding by row. I want to sort these
columns all together so that the corresponding data stays together.
However,
i do not want to have to manually click sort every time my data updates. can
anyone help i really need help im a co-op student and need to get this done
quick

Thanks
--

 

[Gord Dibben]

A co-op student who had better learn to find all the answers to his last couple
of posts if he wants things "done quick".


Gord Dibben MS Excel MVP

 

[bkunes]

well that was the idea
--

A co-op student who had better learn to find all the answers to his last couple
of posts if he wants things "done quick".


Gord Dibben MS Excel MVP

 

[bkunes]

is there any way to tie several columns together, so that when you sort one
column all the tied columns move along with it,