While the linked column on worksheet2 does sort, the related non-linked
columns need to sort with linked column. Else, we need to figure out how to
not sort linked column on worksheet 2 when sorting worksheet 1.

If you're intending to sort a list/datatable, then you shouldn't have
any direct linkages to/from cells outside of that list/datatable. This
would be asking for trouble.

If you do need to pick up information from cells which are in a list to
be sorted, then you need to use formulae which do not depend on the
order in which the data is stored (by rows) within the list/datatable.

An example of a satisfactory link into a sortable table is a Vlookup on
the values in that table.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532375