Hi,
I have a problem where Im building up a file name based on values in a
cell and then doing a sum of a particular column from that file name I
built up. I can do the summing no problem, but cant make the file name
correctly.
I have used the INDIRECT method to build the file name but I need to
have those files actually open as well, which i dont want.
The formual i am using is :
=SUM(INDIRECT("'c:\[doc" & A1 & ".xls]PLA'!$D$1"))
where cell A1 contains the value 200512 and on my c drive I have a file
called
doc200512.xls with a tab called PDA and numeric values in column D.
Can someone please show me how to make the files name up without having
to have the files acutally open?????
I have tried with the INDIRECT function but it only works when the
files are open.
I attached a screen shot where I tried the INDIRECT method.
Thanks
+-------------------------------------------------------------------+
|Filename: untitled.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=4141 |
+-------------------------------------------------------------------+
--
southerndandy
------------------------------------------------------------------------
southerndandy's Profile:
http://www.excelforum.com/member.php...o&userid=29806
View this thread:
http://www.excelforum.com/showthread...hreadid=495147