Can data be copied from one worksheet to another?

T

TinaF

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

Pete_UK

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
 
G

Garyntx

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.
 
Top