IRstuff
That just dumps the results of the concatenation into the cell, it does not actually go out into the file and pull in the requested cell.
Good try,
Thanks
IRSTUFF
That is exactly how I approached it but it would not work for me. My test cell looked something like this:
a1=2000
a2=concatenate("g:\somedir\[somefile]",a1,"deptrate")
a2 then looks like this
g:\somedir\[somefile]2000deptrate
OK, good, thats is what I want.
But...
I need help trying to find a way around this road block.
I want to create a cell, lets say (A1) with a year value, 2000, 2001, 2002 etc.
Later in the file I want to perform a test for a condition, and based on the results, retreive data from an external file of a given name and a tab name of...
