Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to access different files depening on a variable
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to access different files depening on a variable
=INDIRECT("'["Plan 200"&q5-1&" 200"&q5&".xls"]Main'!P36")
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Priorsyeat" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
can't clear read only from files, msg: access denied | Excel Discussion (Misc queries) | |||
how i convert excel files with images to access | Excel Discussion (Misc queries) | |||
how i convert excel files with images to access | Excel Discussion (Misc queries) | |||
how do i create an access code sheet to number my office files an. | New Users to Excel |