Didn't work for me what about you Ralph? I am still trying and I
appreciate those with advice. This one just has me stumped...


Harlan Grove Wrote:
Ralph wrote...
I see a cell formula:
="='C:\Temp\[basefilename"&Text(Today(),"yymmdd")&".xls]Sheet1'!$A$1"
but I want to reference one folder as "A23" and the file as "B23".xls.
then
when I pull the formula down my column I hope it will change the
folder and
file to the values in the A and B columns. still not clear to me :(

Adapt the formula.

="='"&A23&"\["&B23&".xls]"&<sheet and range address here)


--
miwarren
------------------------------------------------------------------------
miwarren's Profile: http://www.excelforum.com/member.php...o&userid=24682
View this thread: http://www.excelforum.com/showthread...hreadid=475955