constructing names in excel (not in VB!)
Posted by Carl Wells on September 24, 2001 3:33 AM
I need to be able to construct a name so that I can use it in a formula. What I mean by construct a name is, using a simple example, imagine a cell, "EUR". I need to be able to read this string from a cell and combine it with "DOLLAR_" and "_FX_RATE" to give the name (already defined elsewhere in the workbook) "DOLLAR_EUR_FX_RATE" for use in a formula
In my problem, the variable is the cell containing "EUR", which thus creates other names e.g. "DOLLAR_CHF_FX_RATE"
another thing I'm going to need to do is create calls to bloomberg along these lines (the ticker used will vary and want to replace that part of the string with a reference to a cell containing the ticker).
Any help much appreciated, I don't want to use VB for this because I want auto updating if I change a cell, and VB would be more work and less transparent (my boss doesn't trust macros either ;) ).
Thanks in advance,