Put this into A1 of Sheet2:

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

then copy it across and down over the area of cells that you want this
to apply to. Then when you enter data into a cell in Sheet1, it will
automatically appear in the same cell in Sheet2.

Hope this helps.

Pete

On Dec 18, 3:11*pm, TinaF wrote:
If I enter data on one worksheet, can that data automatically be copied into
another worksheet?