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

[new Excel user]

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!

 

[Rick Rothstein \(MVP - VB\)]

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

=$H$5

Rick

 

[Rick Rothstein \(MVP - VB\)]

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

=INDIRECT("H5")

Rick

 

[new Excel user]

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

Have a great day!

J.