View original (French)

Formula to copy the value of a cell

Solved
ben -  
Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   -
Hello,

is there a formula to copy the value (and not the formulas) from one cell to another?

For example: in one cell I have the result of a calculation (+A1+B2) = 26. I want to copy this result into another cell. So when the result of my first cell changes, the value in the second cell does not change...

Thank you in advance for your responses.

Best regards,

Ben

Configuration: Windows 7 / Chrome 27.0.1453.116

1 answer

  1.
    Lemay-JP Posted messages 9 Registration date   Status Member Last intervention   4
     
    You copy the cell, go to the other cell and do special paste - values!
    4
    1. Ben
       
      Thank you for your response, but this is not exactly what I'm trying to do. In fact, I want to integrate this special copy-paste into a formula. And once the value is copied from another cell that also contains a formula, if the value in that cell changes, the copied value does not change. Is there a function that allows this? Thank you in advance for your insights...
      0
    2. Babar64420 Posted messages 96 Status Member 3
       
      You need to go through macro. Launch the macro editor, do a copy and paste special/values "manually" into your sheet. Stop the macro editor, and go to the module where it was recorded.
      All that's left to do is to adjust the cell references that you're interested in.
      If you know how to use functions, retrieve the script to adapt it. You will be able to call the function in a cell, as if it were a formula.
      Give it a try, and show us.
      See you later!
      0