columns on worksheet2 don't sort with worksheet1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top