I am trying to access other excel files depending on a variable in my current
worksheet
ie ='["Plan 200"&q5-1&" 200"&q5&".xls"]Main'!P36 such that when q5 is 6 then
the expression will be
='[Plan 2005 2006.xls]Main'!P36
I am trying to access other excel files depending on a variable in my current
worksheet
ie ='["Plan 200"&q5-1&" 200"&q5&".xls"]Main'!P36 such that when q5 is 6 then
the expression will be
='[Plan 2005 2006.xls]Main'!P36
=INDIRECT("'["Plan 200"&q5-1&" 200"&q5&".xls"]Main'!P36")
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Priorsyeat" <[email protected]> wrote in message
news:[email protected]...
> I am trying to access other excel files depending on a variable in my
current
> worksheet
> ie ='["Plan 200"&q5-1&" 200"&q5&".xls"]Main'!P36 such that when q5 is 6
then
> the expression will be
> ='[Plan 2005 2006.xls]Main'!P36
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks