function for conditional value from another worksheet

[Guest]

I'm trying to say if the value in a cell in worksheet A is blank, let the
value in worksheet B also be blank. (Cells are linked)

If the value in a that cell in worksheet A is anything other than blank,
show it in worksheet B.

The linked cells are text, dates, numbers, etc.

Help me!

 

[Ron de Bruin]

You can use a If in the formula

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

 

[Guest]

Instead of : =Sheet1!A1
use: =IF(Sheet1!A1="","",Sheet1!A1)

 

[Guest]

Thank you very much. It worked!

Instead of : =Sheet1!A1
use: =IF(Sheet1!A1="","",Sheet1!A1)

 

[Guest]

Thank you very much. It worked!

You can use a If in the formula

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

 

[Guest]

Thank you very much. It worked!

Marvellous to hear that !
Thanks for the feedback ..

---