software

A1 on Sheet2 =Sheet1!A1

I am trying to make this formula absolute, so if I were to move,cut, or copy
A1 on Sheet1, then A1 on Sheet2 will display what ever is in A1 on Sheet1.
For some reason it keeps changing them every time I cut and paste A1 on
Sheet1 to where ever. I've tried all these ($A$1, $A1, A$1, $A1) and nothing
works? Can anyone Help? Thanks.


Try:

=INDIRECT(quot;Sheet1!A1quot;)

Regards
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=498139that did it thanks!

quot;pinmasterquot; wrote:

gt;
gt; Try:
gt;
gt; =INDIRECT(quot;Sheet1!A1quot;)
gt;
gt; Regards
gt; JG
gt;
gt;
gt; --
gt; pinmaster
gt; ------------------------------------------------------------------------
gt; pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
gt; View this thread: www.excelforum.com/showthread...hreadid=498139
gt;
gt;

Hi,

Try the following formula in A1 of Sheet2.

=INDIRECT(quot;Sheet1!A1quot;)

There could be one problem though. If A1 of Sheet1 is blank, the formula
will return zero in A1 of Sheet2.

Regards,
B. R. Ramachandran

quot;Gabequot; wrote:

gt; A1 on Sheet2 =Sheet1!A1
gt;
gt; I am trying to make this formula absolute, so if I were to move,cut, or copy
gt; A1 on Sheet1, then A1 on Sheet2 will display what ever is in A1 on Sheet1.
gt; For some reason it keeps changing them every time I cut and paste A1 on
gt; Sheet1 to where ever. I've tried all these ($A$1, $A1, A$1, $A1) and nothing
gt; works? Can anyone Help? Thanks.

im trying to do the same thing and the indirect function is now working for me
--
I will Excel at Excel!quot;pinmasterquot; wrote:

gt;
gt; Try:
gt;
gt; =INDIRECT(quot;Sheet1!A1quot;)
gt;
gt; Regards
gt; JG
gt;
gt;
gt; --
gt; pinmaster
gt; ------------------------------------------------------------------------
gt; pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
gt; View this thread: www.excelforum.com/showthread...hreadid=498139
gt;
gt;

=CONCATENATE didnt work either
--
I will Excel at Excel!quot;Ms_M_o_n_i_c_aquot; wrote:

gt; im trying to do the same thing and the indirect function is now working for me
gt; --
gt; I will Excel at Excel!
gt;
gt;
gt; quot;pinmasterquot; wrote:
gt;
gt; gt;
gt; gt; Try:
gt; gt;
gt; gt; =INDIRECT(quot;Sheet1!A1quot;)
gt; gt;
gt; gt; Regards
gt; gt; JG
gt; gt;
gt; gt;
gt; gt; --
gt; gt; pinmaster
gt; gt; ------------------------------------------------------------------------
gt; gt; pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=498139
gt; gt;
gt; gt;

Now im in the same sheet and having indirect issues.

Please correct this formula for me.

M20 equals...
=IF(INDIRECTJ20lt;gt;0,SUM(INDIRECTL20-INDIRECTJ20)/INDIRECTL20,quot;quot;)

when I cut/paste prices from J20 and L20, i get REF or NAME
i need M20 to calculate the GM% formula regardless of what is enter or done
to J20 amp; L20
--
I will Excel at Excel!quot;B. R.Ramachandranquot; wrote:

gt; Hi,
gt;
gt; Try the following formula in A1 of Sheet2.
gt;
gt; =INDIRECT(quot;Sheet1!A1quot;)
gt;
gt; There could be one problem though. If A1 of Sheet1 is blank, the formula
gt; will return zero in A1 of Sheet2.
gt;
gt; Regards,
gt; B. R. Ramachandran
gt;
gt; quot;Gabequot; wrote:
gt;
gt; gt; A1 on Sheet2 =Sheet1!A1
gt; gt;
gt; gt; I am trying to make this formula absolute, so if I were to move,cut, or copy
gt; gt; A1 on Sheet1, then A1 on Sheet2 will display what ever is in A1 on Sheet1.
gt; gt; For some reason it keeps changing them every time I cut and paste A1 on
gt; gt; Sheet1 to where ever. I've tried all these ($A$1, $A1, A$1, $A1) and nothing
gt; gt; works? Can anyone Help? Thanks.