Link sums from worksheet to worksheet

Is there a way to link cells and/or calcs from one worksheet to another
worksheet within the same file? If so, then how? Thanks much.

You simply set a formula to that cell, but include the sheet name

=Sheet2!A1

If the sheet includes embedded spaces, enclose in single quotes

='my sheet'!A1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Mark G." <[email protected]> wrote in message
news:[email protected]...
> Is there a way to link cells and/or calcs from one worksheet to another
> worksheet within the same file? If so, then how? Thanks much.
>
>

What do you mean by embedded spaces?

Thanks much.


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> You simply set a formula to that cell, but include the sheet name
>
> =Sheet2!A1
>
> If the sheet includes embedded spaces, enclose in single quotes
>
> ='my sheet'!A1
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Mark G." <[email protected]> wrote in message
> news:[email protected]...
> > Is there a way to link cells and/or calcs from one worksheet to another
> > worksheet within the same file? If so, then how? Thanks much.
> >
> >
>
>

The example I gave shows what I mean.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Mark G." <[email protected]> wrote in message
news:[email protected]...
> What do you mean by embedded spaces?
>
> Thanks much.
>
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > You simply set a formula to that cell, but include the sheet name
> >
> > =Sheet2!A1
> >
> > If the sheet includes embedded spaces, enclose in single quotes
> >
> > ='my sheet'!A1
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "Mark G." <[email protected]> wrote in message
> > news:[email protected]...
> > > Is there a way to link cells and/or calcs from one worksheet to
another
> > > worksheet within the same file? If so, then how? Thanks much.
> > >
> > >
> >
> >
>
>