[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Off Topic: Excel function



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