text display

Jacun · Jul 24, 2003

How do I display text from one cell in worksheet in
another cell in other worksheet (trough insert function)
THIS is done in the same workbook!!!

Peo Sjoblom · Jul 24, 2003

Can you link to the cell you insert the text in?

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