TMacorke
05-17-2005, 09:06 AM
I'm trying to write a formula in a cell that will allow the file name to vary.
The first three characters of the file name will change depending on the user input of another field on the spreadsheet. I have written the formula below, which DISPLAYS the exact formula that I want excel to EXECUTE....it just doesn't execute the formula in the cell.
="'["&RIGHT(B4,3)&"-DemandPlan-MasterFile V5b.xls]WorldWide'!Q$10" is the formula
'[RAA-DemandPlan-MasterFile V5b.xls]WorldWide'!Q$10 is the results....
the results of this should be the value in cell Q10 from file named RAA-DemandPlan-MasterFile V5b.xls.
How do I get excel to execute the formula in order to display the value from Q10?:help
The first three characters of the file name will change depending on the user input of another field on the spreadsheet. I have written the formula below, which DISPLAYS the exact formula that I want excel to EXECUTE....it just doesn't execute the formula in the cell.
="'["&RIGHT(B4,3)&"-DemandPlan-MasterFile V5b.xls]WorldWide'!Q$10" is the formula
'[RAA-DemandPlan-MasterFile V5b.xls]WorldWide'!Q$10 is the results....
the results of this should be the value in cell Q10 from file named RAA-DemandPlan-MasterFile V5b.xls.
How do I get excel to execute the formula in order to display the value from Q10?:help