I am attempting to simplifiy some template files I created for other
non-Excel users. I would like to make it easier to have users update
formulas, by having the formulas reference a cell for the tab or file
to pull data from. Eample formula:
COUNTIF(*_'DATAFILE.XLS'_*!$J$2:$J$8000,C4). I would like to repalce
DATAFILE.XLS to reference a cell vaule. This way all formulas would
ppoint to one cell where the user would type in the name of the file to
use.
Hope this makes sense....
Anyone ever try this?
Thanks!
--
mgarcia
------------------------------------------------------------------------
mgarcia's Profile:
http://www.excelforum.com/member.php...o&userid=30584
View this thread:
http://www.excelforum.com/showthread...hreadid=502342