Comments:
Hi everybody,
I'm using a couple of functions (spanish version... 'll try to guess their english names) to get a result: I want to manually change RICs in an specific cell and get many related cells and formulas in differente workbooks to update:
Ex: I have this kind of formula (forgive me if sintax is not perfect, just pseudocode talking now):
="[PATH/SOMEBOOK]INTC.O!D543"
I have all data of Dow Jones in SOMEBOOK, which has 30 spreadsheets, each named after a company, jus the RIC.
I do this:
=INDIRECT(CONCATENATE("[PATH/SOMEBOOK]" ; A1 ; "!D543"))
Where A1 is the cell where I enter the ric: INTC.O
I hope the function's names are understandable. Anyway, the point is that I'd like to do the same in charts, that is, I want the SERIES not to be expressed referring to the name of the sheet where data are, but to a cell where that name can be found.
Any ideas?
Txs everybody.
Miguel.
|
