| 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! |
| 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 | |||
Threaded Mode
