Select sheet1 then CTRL + Click on sheet2.

This groups them and what you do to one will be done to the other.

Or, without grouping the sheets, in sheet2 in a cell enter =sheet1!A1

What you enter in A1 of sheet1 will be returned to the cell in sheet2


Gord Dibben MS Excel MVP

On Fri, 4 May 2007 16:03:00 -0700, adella40
wrote:

How do you enter data, simultaneously, in two different worksheets?