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

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!

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!

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

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

=INDIRECT("H5")

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
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!

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

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

Have a great day!

J.

"Rick Rothstein (MVP - VB)" wrote:

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

=INDIRECT("H5")

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
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!