Can data be copied from one worksheet to another?
 

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

Can data be copied from one worksheet to another?
 

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?

Can data be copied from one worksheet to another?
 

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.