PureBytes Links
Trading Reference Links
|
Hi Ed,
> Anyone know how to reference a worksheet name in a cell from another cell?
There is a much easier method available then those suggested so far:
Column Column Formula
A B Col. B
ABC 500 =INDIRECT(A1&"!"&"$E$5")
DEF 1.000 =INDIRECT(A2&"!"&"$E$5")
GHI 1.500 =INDIRECT(A3&"!"&"$E$5")
HTH,
Thomas
- ----- Original Message -----
> Anyone know how to reference a worksheet name in a cell from another cell?
>
> For example:
> I have a list of 10 stock symbols in column "A".
> Each of the 10 stock symbols has a designated worksheet.
> In Column "B" I want to gather the value of the stock as given in the
> designated worksheet. I would like to be able to copy the formula down the
> page once the first one in Column "B" is set.
>
> Column Column
> A B
>
> ABC +ABC!E$5
> DEF +DEF!E$5
> GHI +GHI!E$5
> JKLM .
> NOP .
> . .
> If it were only 10 rows I could do it manually but I have numerous
> spreadsheets all referencing about 70 sheets. I would guess that I have
> about 3000 lines that I need this formula for.
>
> I would really appreciate any help.
>
> thanks in advance,
>
> Ed
----------------------------------------------------------------------------
Thomas Pfluegl, Rudersdorf 8, A - 4212 Neumarkt
Austria Tel. ++ 43 - (0) 7941 - 8106
http://keplerweb.oeh.uni-linz.ac.at/trading/index.html
----------------------------------------------------------------------------
Austria/Europe --> high mountains --> Mozart --> no kangaroos
----------------------------------------------------------------------------
|