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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > is it possible to change info on 1 sheet and make the info change on
> > > another
> > > sheet @ same time?
> >
> >