Thanks for the reply, David.

I just found out about the indirect.ext addin (which I already have
installed, coincidentally enough). However, I can't seem to get it to
work right. Let's say I have the name of a worksheet in A1, we'll call
it "coin value.xls." Here's what I'm using to pull the data from that
worksheet:

'Keyword Groups\Coins\[coin value.xls]Group Costs'!$A$3
What I'm looking for is something like this:
'Keyword Groups\Coins\[A1]Group Costs'!$A$3
This will save me an incredible amount of time :). Any suggestions?

Thanks for your help!


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