External Reference

[believer]

What is the syntax for referencing a cell from another worksheet?
Thanks.

 

[Aladin Akyurek]

On 2002-02-21 11:35, believer wrote:
What is the syntax for referencing a cell from another worksheet?
Thanks.

Lets say that you have a number in A1 in Sheet2 and you want to make a cell (say, C1)in Sheet1 equal to that value:

In C1 in Sheet1 enter: =Sheet2!A1

 

[Mark W.]

On 2002-02-21 11:35, believer wrote:
What is the syntax for referencing a cell from another worksheet?
Thanks.

If that worksheet is in another workbook use...

=[Book1]Sheet1!$A$1

 

[believer]

It worked, thank you both very much.