Complicated Question
Assuming you are typing into Sheet1, then in cell A1 of Sheet2 enter
this formula:
=IF(Sheet1!A1="","",Sheet1!A1)
You can copy this across and down Sheet2 to suit.
Whatever you enter into Sheet1 will be mirrored in Sheet2.
Hope this helps.
Pete
|