 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007How 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! If I understand your question correctly, you would use absolute references ($ signs to fix the row, column or both)... =$H$5 Rick >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 [quoted text clipped - 6 lines] > > Thank you very much! Actually, I think I did misunderstand your question... I think you may want this formula instead: =INDIRECT("H5") Rick > If I understand your question correctly, you would use absolute references > ($ signs to fix the row, column or both)... [quoted text clipped - 13 lines] >> >> Thank you very much! Thank you so much Rich, I tried it and it works. It is exactly what I am looking for. Have a great day! J. > Actually, I think I did misunderstand your question... I think you may want > this formula instead: [quoted text clipped - 20 lines] > >> > >> Thank you very much! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.