Thread
:
How can I assign a data for one cell from another fixed cell?
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Rick Rothstein \(MVP - VB\)
external usenet poster
Posts: 2,202
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!
Reply With Quote
Rick Rothstein \(MVP - VB\)
View Public Profile
Find all posts by Rick Rothstein \(MVP - VB\)