Cell reference in Square Brackets

[Nev]

Hi there

Hope you can help. I want to be able to put a variable in [sqare brackets].
As an example =["a6"]si!e9. Therefore wahtever the work book name in a6,a7,a8
etc will appear in the shaquare brackets which will then link to work sheet
si, cell E(.

Is this possible?

Really look forwrad to hearing from someone

Thanks
Nev

 

[Stefi]

Try this:
=INDIRECT("["&$A$6&"]si!$E$)")

Regards,
Stefi

„Nev†ezt írta:

 

[Nev]

Stefi

that works a treat!! I forgot to add .xls but remembered after sending the
question.

Is there any way to get the link working straight away - the figures will
only update once I have opened the source work book?

Thanks again

Nev

Try this:
=INDIRECT("["&$A$6&"]si!$E$)")

Regards,
Stefi

„Nev†ezt írta:

Hi there

Hope you can help. I want to be able to put a variable in [sqare brackets].
As an example =["a6"]si!e9. Therefore wahtever the work book name in a6,a7,a8
etc will appear in the shaquare brackets which will then link to work sheet
si, cell E(.

Is this possible?

Really look forwrad to hearing from someone

Thanks
Nev

 

[Pete_UK]

INDIRECT will only work with workbooks that are open. You might like
to download the free add-in morefunc (google for places to download it
from), as this contains the function INDIRECT.EXT will does work with
closed workbooks. Note that you will have to include the full path as
well as the file name.

Hope this helps.

Pete

Stefi

that works a treat!! I forgot to add .xls but remembered after sending the
question.

Is there any way to get the link working straight away - the figures will
only update once I have opened the source work book?

Thanks again

Nev

Try this:
=INDIRECT("["&$A$6&"]si!$E$)")

Regards,
Stefi

„Nev” ezt írta:

Hi there
Hope you can help.  I want to be able to put a variable in [sqare brackets].
As an example =["a6"]si!e9. Therefore wahtever the work book name in a6,a7,a8
etc will appear in the shaquare brackets which will then link to worksheet
si, cell E(.
Is this possible?
Really look forwrad to hearing from someone
Thanks
Nev- Hide quoted text -

- Show quoted text -

 

[Nev]

Pete

Thats great

I will give it a try.

Nev

INDIRECT will only work with workbooks that are open. You might like
to download the free add-in morefunc (google for places to download it
from), as this contains the function INDIRECT.EXT will does work with
closed workbooks. Note that you will have to include the full path as
well as the file name.

Hope this helps.

Pete

Stefi

that works a treat!! I forgot to add .xls but remembered after sending the
question.

Is there any way to get the link working straight away - the figures will
only update once I have opened the source work book?

Thanks again

Nev

Try this:
=INDIRECT("["&$A$6&"]si!$E$)")

Regards,
Stefi

„Nev†ezt írta:

Hi there

Hope you can help. I want to be able to put a variable in [sqare brackets].
As an example =["a6"]si!e9. Therefore wahtever the work book name in a6,a7,a8
etc will appear in the shaquare brackets which will then link to work sheet
si, cell E(.

Is this possible?

Really look forwrad to hearing from someone

Thanks
Nev- Hide quoted text -

- Show quoted text -

 

[Pete_UK]

You're welcome.

Pete