|
PureBytes Links
Trading Reference Links
|
I am not clear what you are trying to do. But to see how the links work copy
from one spread sheet to another spread sheet using the past link. Then go
to the formula bar to see the syntax for the link.
Harley
-----Original Message-----
From: Ed Middleton <emiddleton@xxxxxxxx>
To: Metastock list <metastock-list@xxxxxxxxxxxxx>
Date: Tuesday, June 29, 1999 7:37 PM
Subject: Off Topic: Excel function
>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
>
>
|