Linking the worksheets: question about syntax

D

Dmitry Smirnov

Hi, All!

I'm just a general user of Excel and often use formulas like:
"[Budget.xls]Annual!C10". My question is - how can I change that formula in
order to retrieve the name of XLS file from a cell instead specifying it
directly?

I.e. some cell (ex. A1) contains "Budget.xls" text.
And I'd like to use formula like "[#A1#]Annual!C10", where #A1# is syntax
i'd like to know.

Thanks in advance.

SDmitry.
 
T

Tim Zych

=INDIRECT("'" & A1 & "'!C10")

Unfortunately, INDIRECT doesn't work with closed workbooks.
 
D

Dmitry Smirnov

Tim Zych said:
=INDIRECT("'" & A1 & "'!C10")

Unfortunately, INDIRECT doesn't work with closed workbooks.


Dmitry Smirnov said:
Hi, All!

I'm just a general user of Excel and often use formulas like:
"[Budget.xls]Annual!C10". My question is - how can I change that formula in
order to retrieve the name of XLS file from a cell instead specifying it
directly?

I.e. some cell (ex. A1) contains "Budget.xls" text.
And I'd like to use formula like "[#A1#]Annual!C10", where #A1# is syntax
i'd like to know.

Thanks in advance.

SDmitry.
Click to expand...
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

Excel Formula question 0
Worksheet name 3
Copy worksheets and save files dynamically 3
Linking Columns between worksheets 6
Removing Intermediary Links 0
Build a reference to another worksheet from cell values in currentsheet 3
Find the last row using 2 to 20 criteria 8
need help with syntax of if statement 3

Top