Referencing a cell from another worksheet

[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

 

[Anne Troy]

=sum(f4+Sheet1!A1)

************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[Guest]

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]

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


Mark

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

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