View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gabe
 
Posts: n/a
Default Absolute Formula Help

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.