Absolute Formula Help

[Guest]

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.

 

[pinmaster]

Try:

=INDIRECT("Sheet1!A1")

Regards
JG

 

[Guest]

that did it thanks!

 

[Guest]

Hi,

Try the following formula in A1 of Sheet2.

=INDIRECT("Sheet1!A1")

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

 

[Ms_M_o_n_i_c_a]

im trying to do the same thing and the indirect function is now working for me

 

[Ms_M_o_n_i_c_a]

=CONCATENATE didnt work either

 

[Ms_M_o_n_i_c_a]

Now im in the same sheet and having indirect issues.

Please correct this formula for me.

M20 equals...
=IF(INDIRECTJ20<>0,SUM(INDIRECTL20-INDIRECTJ20)/INDIRECTL20,"")

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