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

"Mark" <mark_news@horsemad.co.uk> wrote in message
news:cDtCf.110847$7p5.72102@newsfe4-win.ntli.net...
> 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
>

[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




"Mark" wrote:

> 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
>
>
>

[Mark]

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


Mark


"CLR" <CLR@discussions.microsoft.com> wrote in message
news:24A3B842-9473-4051-9841-CA12073BE588@microsoft.com...
> 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" wrote:
>
>> 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
>>
>>
>>