update info on 2 sheets @ same time
 

is it possible to change info on 1 sheet and make the info change on another
sheet @ same time?

Yes if you link them assume you put info in Sheet1 A1 then in Sheet2 A1 put

=Sheet1!A1

--
Regards,

Peo Sjoblom


"dg" wrote in message
...
is it possible to change info on 1 sheet and make the info change on
another
sheet @ same time?

tried that and got update values dialog box. wasn't expecting that

"Peo Sjoblom" wrote:

Yes if you link them assume you put info in Sheet1 A1 then in Sheet2 A1 put

=Sheet1!A1

--
Regards,

Peo Sjoblom


"dg" wrote in message
...
is it possible to change info on 1 sheet and make the info change on
another
sheet @ same time?

got it
thanks

"dg" wrote:

tried that and got update values dialog box. wasn't expecting that

"Peo Sjoblom" wrote:

Yes if you link them assume you put info in Sheet1 A1 then in Sheet2 A1 put

=Sheet1!A1

--
Regards,

Peo Sjoblom


"dg" wrote in message
...
is it possible to change info on 1 sheet and make the info change on
another
sheet @ same time?