In a cell on target worksheet enter this formula..........

=Sourcesheet!A1


Gord Dibben MS Excel MVP

On Mon, 16 Apr 2007 11:46:10 -0700, Lori Evans
wrote:

how can information entered in one worksheet automatically show/display in
another worksheet?