If I enter data on one worksheet, can that data automatically be copied into
another worksheet?

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?

Disregard the first reply...Sorry Pete.

All you have to do is select each sheet tab by either using control or
shift. Every sheet that is highlighted will be inputed with the value you
enter.