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

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

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

"Stefi" wrote:

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

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

On Dec 8, 3:23*pm, Nev wrote:
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



"Stefi" wrote:
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

Thats great

I will give it a try.

Nev

"Pete_UK" wrote:

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

On Dec 8, 3:23 pm, Nev wrote:
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



"Stefi" wrote:
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 -

You're welcome.

Pete

On Dec 10, 1:02*pm, Nev wrote:
Pete

Thats great

I will give it a try.

Nev