What formula do you use for Microsoft Excel that references info on the 1st worksheet from a 2nd worksheet?

Question

I have to research a way to create a formula using Microsoft Excel and it has to do with referencing information on one worksheet from a second worksheet. Can anyone help me? All I need is the formula to do this referencing. I searched all over, but couldn't find anything on referencing. Please help! Thank you in advance!

Answer 1

I don't have a copy of Excel to check, but I believe you can name the sheets (by right-clicking on the tab?)

Then let's say you want to access the cell D5 on  MySheet 1  from a cell in sheet 2.  Try the formula 'MySheet 1'!D5 in a cell on sheet 2.

If you don't have a space in your sheet name you might get by without the quote marks?

Not sure, but I think that's how it it worked some time ago.

Answer 2

To reference another cell, or link to a cell:

=A1

To link to a cell in another sheet:

='Sheet1'!A1

To link to a cell on another workbook:

='[book1.xls]Sheet1'!A1

Answer 3

Do you have to use a formula in a cell on one worksheet that incorporates a formla in a cell on a second worksheet in the same workbook?  Is that what you are asking?

Hit = then go to the second worksheet, click on the cell you are referencing then + or - or whatever action you want to use that answer to calculate with another cell on the first worksheet, go to the first worksheet and click on the cell with the value you are using and hit enter.  Hope this helps, hope it is what you were asking.