View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default How can I assign a data for one cell from another fixed cell?

If I understand your question correctly, you would use absolute references
($ signs to fix the row, column or both)...

=$H$5

Rick


"new Excel user" <new Excel wrote in message
...
I can assign data to one cell by put formular, for example: =H5.
But if I add a row, my cell will get data from H6, Excel automatically
modified my formular to: =H6
And now I want the data always come from =H5, no matter how many rows I
add
on top of it.

PLease help me. I remember somebody did it, but I forget it.

Thank you very much!