Link cell
 

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

Link cell
 

You can check first:

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



neilbrown1965 wrote:

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