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.
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.
> > >
> > >
> >
> >
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks