Link cell

[neilbrown1965]

When using the above. When the source cell is empty the target cell has data,
how can I get rid, so the target cell is blank until source cell has data

 

[Dave Peterson]

You can check first:

=if(b99="","",b99)
or
=if(sheet1!a1="","",sheet1!a1)