Link sums from worksheet to worksheet

M

Mark G.

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

Bob Phillips

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)
 
B

Bob Phillips

The example I gave shows what I mean.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top