How to reference cell in different worksheet?

B

Brett

How do I reference a cell in the same workbook but different worksheet?

Thanks,
Brett
 
P

Paul B

Brett, something like this =Sheet2!D1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
R

RagDyer

An easy way to have XL do it for you:

To just create a link, enter an equal sign in the cell of the current sheet,
then click the sheet tab you're interested in linking to, and then click in
the cell that you wish to link to, and see the linking formula in the
formula bar *before* you hit <Enter>.

To use it in a formula, when it's time to enter the cell address, just
navigate to the sheet and cell of concern, just as above, and its entered
for you by XL, and you can continue entering the balance of your formula.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

How do I reference a cell in the same workbook but different worksheet?

Thanks,
Brett
 
B

Brett

I tried to do this with a "name" definition for three cells and use
that to fill a drop down list form object. I click the first cell
then go to Insert | Name | Define. The name I want to call this cell
is already listed (from previous tries). I click it and that name
jumps up into the "Names in workbook" field. I see the formula in
"Refers to" for the three cells I tried to name:

=Main!$B$26+'15 Hours Overtime'!$B$9+'30 Hours Overtime'!$B$9

That all looks correct. Three cells on three different sheets.
However, after closing the Define box, I click on any of the three
cells and the name does not appear, just the cell number. Therefore,
the name is not taking affect. What did I do wrong?

My goal is to populate the drop down list box with the values of three
cells on three different sheets. I want some one to choose one of
three values in the drop down and have that value used in a formula on
the same sheet as the drop down. Since I can't just comma seperate
the fields in the drop down "input range", I thought a name
defeinition would work. How can I populate the drop down this way?

Thanks,
Brett
 
Top