Let's say you have 2 sheets in your workbook. In sheet2 put this formula in
cell A1:
=IF(ISBLANK(Sheet1!A1);"";Sheet1!A1)
In sheet1cell A1 put some number or text, press Enter, go back to sheet2 and
check if it copied what you wrote in A1.

Swisse