| 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 | |||
Hybrid Mode
