PureBytes Links
Trading Reference Links
|
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
|