<div>
Please note INDIRECT references to another workbook only work when the source workbook is open.<br />
<br />
if you close the source workbook, the formula will show an error.<br />
<br />
Thanks<br />
Rob H
</div>


Please note INDIRECT references to another workbook only work when the source workbook is open.

if you close the source workbook, the formula will show an error.

Thanks
Rob H

<div>
Yes, thanks, Rob.<br />
<br />
I was anticipating further dialogue with <i>armgon</i> prior to the question being closed.<br />
<br />
If it had transpired that the workbook was closed, I would have suggested using a routine similar to the one I posted within a recent thread:<br />
<br />
[ <a href="https://www.experts-exchange.com/questions/28668894/Excel-Data-Transfer-via-SQL-Call.html?anchorAnswerId=40779101#a40779101" rel="ugc">https://www.experts-exchange.com/questions/28668894/Excel-Data-Transfer-via-SQL-Call.html?anchorAnswerId=40779101#a40779101</a>&nbsp;]
</div>


Yes, thanks, Rob.

I was anticipating further dialogue with armgon prior to the question being closed.

If it had transpired that the workbook was closed, I would have suggested using a routine similar to the one I posted within a recent thread:

[ https://www.experts-exchange.com/questions/28668894/Excel-Data-Transfer-via-SQL-Call.html?anchorAnswerId=40779101#a40779101 [https://www.experts-exchange.com/questions/28668894/Excel-Data-Transfer-via-SQL-Call.html?anchorAnswerId=40779101#a40779101] ]

<div>
The formula works great.<br />
<br />
These workbooks are set up with data that needs to be opened at same time.<br />
<br />
Thanks for the efforts.
</div>


The formula works great.

These workbooks are set up with data that needs to be opened at same time.

Thanks for the efforts.

<div>
You're very welcome. &nbsp;Happy to help. &nbsp;Thanks for returning to offer feedback too.
</div>


You're very welcome.  Happy to help.  Thanks for returning to offer feedback too.

<div>
<div class="content wysiwyg-content">
I currently use a formula like the one below:<br />
='[Financial Statement Workbook Final Drafts_122011.xlsx]Balance<wbr /> Sheet'!$BF$11<br />
<br />
I would like to make the reference to &quot;BF&quot; a value which is entered on this same sheet on column H row 1<br />
<br />
Your help with the correct format would be greatly appreciated.
</div>
</div>


I currently use a formula like the one below:
='[Financial Statement Workbook Final Drafts_122011.xlsx]Balance Sheet'!$BF$11

I would like to make the reference to "BF" a value which is entered on this same sheet on column H row 1

Your help with the correct format would be greatly appreciated.

Excel Formula linked to other Workbook

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.