I need help with Excel, I want to reference a cell from a different worksheet.?

Question

I have two worksheets in a single Excel file. I would like to include the sum of the values in sheet#1 as a precedent in sheet#2. This has to be simple, but I can't make it happen. I checked the help section, which mentions the capability to use values from different sheets, but it does not describe how. I have also tried all of the Paste-Special features to no avail. It's important to mention that I want the precedent in sheet#2 to update automatically whenever the referenced cell in sheet#1 is changed. Thanks!

Answer 1

just reference the sheet name, followed by the cell(s) on that sheet that you would like to have in any cell - like this:
=Sheet1!A1

you can also do this by typing an = in the cell, then using your mouse to to go the sheet and cell(s) you want to link to, then press enter. this will create the formula without you typing it manually.

you can also create links to sheets and cells in other workbooks this way, although the link is not updated automatically as it is when you reference cells and sheets in the same workbook.

Answer 2

You need to write the formula then click on the worksheet & Cell you want to reference - it should be straightforward, if it is a seperate worksheet - make sure you have it open first & have both windows showing

Answer 3

Right-click on the cell you want to refrence on page 1 and click on copy. Switch over to page 2, right-click on the cell you want to paste a link to it and click on paste-special. Then select "Paste Link"

That will give you an example of how to refrence it. Just click on the cell to see how it worked.