How can I assign a data for one cell from another fixed cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
If I understand your question correctly, you would use absolute references
($ signs to fix the row, column or both)...

=$H$5

Rick
 
Actually, I think I did misunderstand your question... I think you may want
this formula instead:

=INDIRECT("H5")

Rick
 
Thank you so much Rich, I tried it and it works. It is exactly what I am
looking for.

Have a great day!

J.
 
Back
Top