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