formula issues
 

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

formula issues
 

Group them first, select both worksheets, do your stuff, then ungroup them


--
Regards,

Peo Sjoblom



"adella40" wrote in message
...
How do you enter data, simultaneously, in two different worksheets?

formula issues
 

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?