I want to reference the content of of D13 in the below formula:
SUM('[BRT Weekly Resource Report_3-22-11.xls]BRT Report'!$S$7:$S$25)
Cell D13 current has the text value:
C:\Documents and Settings\g1gq\Desktop\Weekly Resource Report\Source Data\BRT Weekly Resource Report_3-22-11.xls
Cell D13 is populated (value only) as files are imported. I know there is a method to program this reference, I just can't remember it for the life of me.
Thanks in advance
Bookmarks