Question about Linking cells on different sheets

[zoog25]

Hello all,

This might sound like a dumb questions but i'm wondering. Is there a way to permanently link data from one sheet to another. For example on Sheet 1 Cell "E4" i have the code like "18-0400", then i will like to have sheet 2 Cell "F8" link to the data. My questions is that if say i were to data sort sheet 1 and say "E4" becomes "E37", will sheet 2 Cell "F8" update to "E37" if the value of sheet 2 cell "F8" just equals "='Tract Parcels'!E4". In this case Sheet 1 is called 'Tract Parcels'. Or is there a special code that i need to include in order to account for the change.

 

[bobsan42]

Don't be afraid to try and see what happens.
There are various ways to get data from a cell. Some of them will follow the cell around and some won't.
Normally however I wouldn't play with raw data - sorting, filtering etc. would be done in the resulting table.

Ref like =sheet1!E4 will link to the cell and follow it wherever it goes .
Reference like =sheet1!E:E will not.

 

[zoog25]

Thanks for the advice bobsan42. In this case it is just cell to cell matching. Not column or row, just one cell matches one cell on another sheet and both should stay linked.