software

I have a formula (see below) that I want to be able to drag and copy so
that the text in cells A1:A60 copies automatically into the formula.
These are stock symbols. Where you see quot;SYMquot; is where I need the text
in cells A1:A60 to go. Each cell has a unique symbol. Here's the
formula.

=RediLINK|'L1'!'SYM;Vol'--
jimbob
------------------------------------------------------------------------
jimbob's Profile: www.excelforum.com/member.php...oamp;userid=29107
View this thread: www.excelforum.com/showthread...hreadid=516920have a look in the help index for INDIRECT

--
Don Guillett
SalesAid Software

quot;jimbobquot; gt; wrote in
message ...
gt;
gt; I have a formula (see below) that I want to be able to drag and copy so
gt; that the text in cells A1:A60 copies automatically into the formula.
gt; These are stock symbols. Where you see quot;SYMquot; is where I need the text
gt; in cells A1:A60 to go. Each cell has a unique symbol. Here's the
gt; formula.
gt;
gt; =RediLINK|'L1'!'SYM;Vol'
gt;
gt;
gt; --
gt; jimbob
gt; ------------------------------------------------------------------------
gt; jimbob's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29107
gt; View this thread: www.excelforum.com/showthread...hreadid=516920
gt;

I don't think that applies. I am not looking for indirect reference to
another cell. I simply want the text in cell A1 to be placed in the
formula. Cells A1 thru A60 contain stock symbols. I want to enter the
formula once and then be able to copy it down and have the field quot;SYMquot;
automatically populate with whatever symbol is in the corresponding A
col. I would think this would be pretty easy, but I can't find any help
in the documentation. Thanks for your help.--
jimbob
------------------------------------------------------------------------
jimbob's Profile: www.excelforum.com/member.php...oamp;userid=29107
View this thread: www.excelforum.com/showthread...hreadid=516920if I have sheet11 typed into cell a10 and use
=INDIRECT(A10amp;quot;!A1quot;)
I will get the same as =sheet11!a1
--
Don Guillett
SalesAid Software

quot;jimbobquot; gt; wrote in
message ...
gt;
gt; I don't think that applies. I am not looking for indirect reference to
gt; another cell. I simply want the text in cell A1 to be placed in the
gt; formula. Cells A1 thru A60 contain stock symbols. I want to enter the
gt; formula once and then be able to copy it down and have the field quot;SYMquot;
gt; automatically populate with whatever symbol is in the corresponding A
gt; col. I would think this would be pretty easy, but I can't find any help
gt; in the documentation. Thanks for your help.
gt;
gt;
gt; --
gt; jimbob
gt; ------------------------------------------------------------------------
gt; jimbob's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29107
gt; View this thread: www.excelforum.com/showthread...hreadid=516920
gt;