Link sums from worksheet to worksheet

  • Thread starter Thread starter Mark G.
  • Start date Start date
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.
 
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)
 
The example I gave shows what I mean.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
trying to create a link to a link in Excel (2007) 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Scatter plot / Data from matrices? 1
Email Worksheet Question 3
Excel Multiple Worksheets - TransferSpreadsheet VBA 0
Excel lookup across entire workbook 1
Make Chart refer to user defined worksheet 4

Back
Top