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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Values in linked Cells Only 4
linking cells to other sheets within a workbook 1
linking within a workbook and sorting 2
Conditional formatting 3
Linked cells return #Ref when they shouldn't! 2
cells linked from worksheet to worksheet 1
Sort Contiguous Columns - Danger 3
copy rows from one Data sheet to another sheet based on cell conte 2

Back
Top