Sorting linked cells

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

Guest

I have a single workbook with multiple columns linked from the main data sheet to other sheets. When I sort the main sheet, the data in the linked cells changes in the dependent sheets, and no longer corresponds to other data entered in the corresponding row of the dependent sheet(s)

In other words, the cells are linked, but the data is not...and what I really need is for the rows of data to all be "locked" together

It seems that this is a pretty basic function, and I imagine that there is a very simple answer staring me in the face, since I can find absolutely no discussion of this problem in Help or in Support..

Thanks for your help
 
Maybe you can use some other technique than just simple links to cells.

Maybe =vlookup()'s would do it--if you have a key column that is shared between
the worksheets and no duplicates in that column.
 
Back
Top