How do I reference a cell in another worksheet

[Lawrence M. Seldin, CMC, CPC]

In Excel 2000, I created a new sheet. How do I reference a cell value from another sheet in the same
spreadsheet.

Thanks much,


Lawrence M. Seldin, CMC, CPC
Author of POWER TIPS FOR THE APPLE NEWTON and INTRODUCTION TO CSP
Author of RECRUITSOURCE PEOPLESOFT EXAM and RECRUITSOURCE SAP/R3 EXAM


NOTE: To send me an email, remove TAKEOUT from my email address: (e-mail address removed)

NOTE: My web home page: www.seldin.net

 

[Dave R.]

use SheetName, a !, then the cell ref.

E.g.

=Sheet1!A1

will bring the content of A1 from sheet1 over to wherever you put that
formula (as long as it's not in Sheet1..)

 

[Gord Dibben]

Lawrence

In A1 of Sheet1 enter.........

=Sheet2!A1 returns the value

=B3 + Sheet2!A1 adds the two values

=SUM(B3:G3 + Sheet2!A1) adds the values from all cells

Many other variations.

Gord Dibben Excel MVP

 

[Mark Graesser]

Hi Lawrence
The easest way is to type an equal sign in the cell where you want the formula, then, without hitting enter, use your mouse to switch to the other sheet and click on the cell. Then hit enter. The reference will be created automatically

If you want to type the reference then use the sheet name followed by an exclamation point

ex. =sheet2!A

would reference cell A1 on sheet2. If the sheet name has a space in it you need to surround it with apostrophes

ex. ='Second Sheet'!A

this will reference cell A1 on a sheet named Second Sheet

Good Luckl
Mark Graesse
(e-mail address removed)
Boston M

----- Lawrence M. Seldin, CMC, CPC wrote: ----

In Excel 2000, I created a new sheet. How do I reference a cell value from another sheet in the sam
spreadsheet

Thanks much


Lawrence M. Seldin, CMC, CP
Author of POWER TIPS FOR THE APPLE NEWTON and INTRODUCTION TO CS
Author of RECRUITSOURCE PEOPLESOFT EXAM and RECRUITSOURCE SAP/R3 EXA


NOTE: To send me an email, remove TAKEOUT from my email address: (e-mail address removed)

NOTE: My web home page: www.seldin.ne

 

[Lawrence M. Seldin, CMC, CPC]

Mark, David and Gord,

Worked great.

Thanks much,

Lawrence M. Seldin, CMC, CPC
Author of POWER TIPS FOR THE APPLE NEWTON and INTRODUCTION TO CSP
Author of RECRUITSOURCE PEOPLESOFT EXAM and RECRUITSOURCE SAP/R3 EXAM


NOTE: To send me an email, remove TAKEOUT from my email address: (e-mail address removed)

NOTE: My web home page: www.seldin.net