| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want Vlookup Result in one fixed Cell while Entring Data in a Sh | Excel Discussion (Misc queries) | |||
| How do I assign a fixed number value to text? | Excel Discussion (Misc queries) | |||
| How do i assign cell A1 to show the current cursor cell in Excel? | Excel Discussion (Misc queries) | |||
| Charts: want to assign fixed color for each slice | Excel Discussion (Misc queries) | |||
| Charts: want to assign fixed color for each slice | Charts and Charting in Excel | |||
Linear Mode
