I'm using forumulas like these to extract data from several different
files: =SUM('Coins\[coin value.xls]Group Costs'!$A$3). I have a column
that has all the filenames listed, but it's a huge hassle to go through
and change the formula each time I start a new row (keyword). What I
need is something like this: =SUM('Coins\[A3.xls]Group Costs'!$A$3). -
As you can see, I'm trying to get Excel to think that A3 really equals
'coin value'. I know this is possible with concatenation (it would take
a few extra steps) but I need all the data right in front of me as I'm
working.

Does anyone know of any solution to my dilemma?

Thank you.


--
AlexJ
------------------------------------------------------------------------
AlexJ's Profile: http://www.excelforum.com/member.php...o&userid=27247
View this thread: http://www.excelforum.com/showthread...hreadid=467559