='[April 06_Revenue.xls]Summary'!$A$1
What I want to do is use a named range in the place of "April 06" in the above link so that I don't have to update links for every month.
I would like to just change the period in the named range (called "period") and have all the links updated.
I tried to put the variable in the link as follows:
="'["&Period&"_Revenue.xls]Summary'!"&$A$1
but I get a formula error...anyone know how I can get this to work?
What I want to do is use a named range in the place of "April 06" in the above link so that I don't have to update links for every month.
I would like to just change the period in the named range (called "period") and have all the links updated.
I tried to put the variable in the link as follows:
="'["&Period&"_Revenue.xls]Summary'!"&$A$1
but I get a formula error...anyone know how I can get this to work?