Link sums from worksheet to worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark G. - 09 Jan 2006 07:20 GMT

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.

Reply to this Message

Bob Phillips - 09 Jan 2006 08:49 GMT

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

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> 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.

Reply to this Message

Mark G. - 09 Jan 2006 09:50 GMT

What do you mean by embedded spaces?

Thanks much.

> You simply set a formula to that cell, but include the sheet name
>
[quoted text clipped - 6 lines]
> > 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.

Reply to this Message

Bob Phillips - 09 Jan 2006 10:58 GMT

The example I gave shows what I mean.

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> What do you mean by embedded spaces?
>
[quoted text clipped - 10 lines]
> > > 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.

Reply to this Message