Making Address function & references as links to external files ??
If try this in Help:
Absolute reference to another workbook and worksheet ([Book1]Sheet1!R2C3)
And I type this code: G4 is a text: RDCForecastHV-04172005.CSV
=ADDRESS(3,2,1,FALSE,G4)
I get this result:
'RDCForecastHV-04172005.CSV'!R3C2
But it won't link to a file.
If I just type in a cell: or Link it directly as this:
='RDCForecastHV-04172005.CSV'!$B$3
I get some arbitrary data result: 134 in the other file.
IF I take it a step furthur: I want to lookup data in a filename I'm
creating, use a variable input for my match, and pull data from specific
columns of that variable row. I'm doing this to short cut updating and
adding more links to a excel file from multiple data sources that I want to
continue add to my main file.
Has anyone ever accomplished this task? I would really like to get it to
work, the alternative is create 20 links into 4 seperate files for each day
of the week for each another variable of data of upto 20 match possibilities.
Thanks,
Dennis
|