How to edit the link?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

='[DataSource.xls]6227.ABC'!$C$2, which work in cell A1, but
I would like to retrieve the value 6227 from cell B1 for this statement
instead of manually input the value 6227 into the string.
Does anyone have any suggestion?
Thank you in advance
Eric
 
As long as DataSource.xls is open, you could use:
=indirect("'[DataSource.xls]" & b1 & ".ABC'!$C$2")

=indirect() won't work if the "sending" workbook is closed.

='[DataSource.xls]6227.ABC'!$C$2, which work in cell A1, but
I would like to retrieve the value 6227 from cell B1 for this statement
instead of manually input the value 6227 into the string.
Does anyone have any suggestion?
Thank you in advance
Eric
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to edit the link? 1
How to retrieve the value within string? 10
How to detect characters with a cell? 12
How to use indirect function? 2
How to retrieve certain text from string? 5
How to retrieve the value? 3
How to retrieve the values within cells? 4
How to set the formula? 5

Back
Top