Formula to Value Problem

[breakr19]

I am trying to overcome a problem that I'm having trying to convert a formula result in one cell to that same value in a different cell.

I have read all about the copy and paste value method, but that does not work for me because I want to then take the new value and paste it in to a new sheet without having to copy and paste value every time.

In essence, I am looking for a formula that does the following:

O68=SUM(L4:L8)

C89=O68, with C89 being the value of the formula. So, then I can copy C89 into another sheet so that it transfers the value present in C89 rather than the formula found in O68.

Can anyone help me with that, and feel free to ask more questions of me if it was not clear?

 

[wigi]

If you do not want to do this manually, you will have to use VBA:

Range("C89").Value = Range("O68").Value

Amend as needed.

 

[breakr19]

Thank you for the quick answer.

I have never messed with VBA until now, and it's not too difficult, so I appreciate everything!

 

[wigi]

I have never messed with VBA until now, and it's not too difficult, so I appreciate everything!

It's indeed fair to say that there are more difficult macros than the one above

Glad to help you.