ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell Linking (https://www.excelbanter.com/excel-discussion-misc-queries/59872-cell-linking.html)

buzzfever

Cell Linking
 

I'm not sure if "cell linking" is the correct terminology for what I
need but all I want to do is have 3 columns, 2 of which are
alphanumeric, and when any column is resorted the other 2 columns
should resort also so that the rows will always stay the same.
Thanks.


--
buzzfever
------------------------------------------------------------------------
buzzfever's Profile: http://www.excelforum.com/member.php...o&userid=29553
View this thread: http://www.excelforum.com/showthread...hreadid=492578


Ron Coderre

Cell Linking
 

Make sure you select ALL 3 COLUMNS before you sort. Then, when you
DataSort...just select the column you want to sort. That should keep
them all together.

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=492578


buzzfever

Cell Linking
 

yea, that worked great. thank you so much!


--
buzzfever
------------------------------------------------------------------------
buzzfever's Profile: http://www.excelforum.com/member.php...o&userid=29553
View this thread: http://www.excelforum.com/showthread...hreadid=492578



All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com