EDIT FORMULA REFERENCE

[HotNumbers]

This is my current formula

=+'C:\BVPM\SHARE\FORECAST\Forecast Summary\FY07\[Forecast Change Summary 10-04-06.xls]07_Summary'!$M$6

I need to have the ability to change 10-04-06 using a cell reference point. for example 10-04-06 will change to 10-11-06, etc....

How can I change the formula to reference Cell A1 which will have the reference date.

 

[Domski]

You can use the Indirect function to construct references including the contents of cells however the standard Excel function does not work on external files unless they are open.

I believe there is an Indirect function included in the Morefunc add-in that does work with external files though.

Have a look here:

http://www.mrexcel.com/board2/viewtopic.php?t=131224

Dom