Linking and Sorting worksheets

  • Thread starter Thread starter skully51
  • Start date Start date
S

skully51

I want to link a cell in Worksheet A to equal a cell in Worksheet B.
Worksheet B has many columns and rows of data that I want to link to
worksheet A. I can link the worksheets and have the correct values show
in A.


Problem: I need to be able to sort Worksheet B and maintain the same
values in worksheet A. So if I sort Worksheet B, and for example
Worksheet B cell A1 had the name Jake in it, but now Jake moved to
A20,I want my link to follow Jake to A20. Can this be done. The formula
moves when adding cells or deleting cells in Worksheet B but does not
seem to move with the cell when sorting worksheet B. Is this a setting
or am I out of luck????? Thanks
 
I think you're out of luck.

You may want to try to keep all your data on one worksheet. Maybe you could use
Data|Filter to show just what you want (instead of extracting to a new sheet).

On the other hand, if you type "Jake" in sheet2 and want to retrieve something
from Sheet1 and place it in the next column in Sheet2, you maybe be able to use:

=vlookup()
or even
=index(match())

Debra Dalgleish has some nice instructions at:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html
 
Back
Top