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

Re: Off Topic: Excel function



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
----------------------------------------------------------------------------