Use this large white space to explain your problem more fully.

You would generally use a formula like:

=IF(Sheet1!A1="","",Sheet1!A1)

to bring the contents from A1 of Sheet1 to another cell, but there are
other ways which might be more suitable, depending on your exact
requirements. For example, if the cell with the formula is to be
dependent on another cell, then you might use one of the LOOKUP
functions, or an INDEX/MATCH combination.

Please describe what you want to achieve in more detail.

Hope this helps.

Pete

On Aug 28, 3:31*pm, Hyperlinking Spreadsheets <Hyperlinking
wrote:
the content automatically update?