View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default 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