Referencing a cell from another worksheet

M

Mark

Hi,

I'm sure this is very simple, but can someone please tell me the syntax to
access a cell from another worksheet?

e.g. =sum(F4+sheet[1]_A1)


Also, is it possible to access a cell from another /file/ ? Id imagine not
for security reasons, but thought I would ask whilst I am here.



Many thanks for your help,


Mark
 
C

CLR

For within the same Workbook.........

=f4+Sheet1!A1)

To retrieve from another workbook...........

=F4+'C:\_ChuckStuff\[book2.xls]Sheet1'!A1

Adjust the path and filename accordingly.....

Vaya con Dios,
Chuck, CABGx3
 
M

Mark

Fantastic - Thank you very much to both posters, it works a dream!


Mark


CLR said:
For within the same Workbook.........

=f4+Sheet1!A1)

To retrieve from another workbook...........

=F4+'C:\_ChuckStuff\[book2.xls]Sheet1'!A1

Adjust the path and filename accordingly.....

Vaya con Dios,
Chuck, CABGx3




Mark said:
Hi,

I'm sure this is very simple, but can someone please tell me the syntax
to
access a cell from another worksheet?

e.g. =sum(F4+sheet[1]_A1)


Also, is it possible to access a cell from another /file/ ? Id imagine
not
for security reasons, but thought I would ask whilst I am here.



Many thanks for your help,


Mark
Click to expand...
Click to expand...
 
Top