View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Yupkwondo
 
Posts: n/a
Default Easy Sorting Question


Hello,

I am an excel beginner, and need some assistance. I don't excactly know
how to explain this so I will to my best.

I have info in 20 columns, I want to be able to sort it by any one of
those columns and have the info that is next to it stay attached to the
column next to it.

For example, I have data in row 1 that are in cells A1 and B1 that are
related, and row two, in cells A2 and B2 that are related, and so on
for A3, B3.... If I wanted to sort by column A, I want the relevant
data in B to move according to what was changed in A, and to do the
same if I were to sort by B and have A stay attached. How do I do
that?

I hope that makes sense. Thank You.

~ Jason Gross


--
Yupkwondo
------------------------------------------------------------------------
Yupkwondo's Profile: http://www.excelforum.com/member.php...o&userid=26391
View this thread: http://www.excelforum.com/showthread...hreadid=528791