B
ben.sullins
Hello all...
My goal with this report is to link to an external workbook.
I am using a formula to dynamically create the file I will be linkin
to.
="'\\Igus-amd-0320\Operations\Operations Info\AC
Reports\[ACD_Daily_Paste_"&TEXT(MONTH(C5-7)&"/"&DAY(C5-7)&"/"&YEAR(C5),"mmm")&".xls]"&TEXT((C5-7),"mmdd")&"-Sum'!$A$3:$w$200"
Returns
'\\Igus-amd-0320\Operations\Operations Info\AC
Reports\[ACD_Daily_Paste_Aug.xls]0824-Sum'!$A$3:$w$200
The formula result is the exact range I need in my formula, my dilem
is that when I try to combine my lookup formula with the formula abov
I recieve a #Value error.
I have tried to use the Indirect() function, but for that to work th
workbook i'm linking too must be open, which will not work in my case.
Anything would help, thanks for your consideration
Ben Sullin
My goal with this report is to link to an external workbook.
I am using a formula to dynamically create the file I will be linkin
to.
="'\\Igus-amd-0320\Operations\Operations Info\AC
Reports\[ACD_Daily_Paste_"&TEXT(MONTH(C5-7)&"/"&DAY(C5-7)&"/"&YEAR(C5),"mmm")&".xls]"&TEXT((C5-7),"mmdd")&"-Sum'!$A$3:$w$200"
Returns
'\\Igus-amd-0320\Operations\Operations Info\AC
Reports\[ACD_Daily_Paste_Aug.xls]0824-Sum'!$A$3:$w$200
The formula result is the exact range I need in my formula, my dilem
is that when I try to combine my lookup formula with the formula abov
I recieve a #Value error.
I have tried to use the Indirect() function, but for that to work th
workbook i'm linking too must be open, which will not work in my case.
Anything would help, thanks for your consideration
Ben Sullin