MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying values, not formulas, via a formula

Posted by Simon on January 28, 2002 4:03 AM


I need to copy a result value from one column to the next - unfortunately when I copy it something seems to make it appear as another number. How can I get a formula to copy a result and not the formula?

E.g. If data is in A and the formula is in B (=A1) - this seems to bring up something different.


Posted by Ivan F Moala on January 28, 2002 4:24 AM

If I undertand you correctly then what you are looking
for is to copy over the Values of the formulas ONLY ??
If so then Select the range to copy.
Select Edit | Copy
Select the Top cell to copy to
Select Edit | paste Special
click on Values
Click OK

have a look @ online help for this as well.



Posted by Simon on January 28, 2002 4:40 AM

You're correct about the problem - unfortunately I need to be able to copy just the value via a formula. I have sets of date data that produces productivity figures, one of which is to do with deadlines. The result is a number but when I reference a formula on that result it comes up with something different.

I tried manually copying as you suggested but this also produces the same result as before.


Posted by Chris D on January 28, 2002 12:50 PM

Hi Simon,

Do you mean that you want the result of the formula to always also appear in a different cell, so that you don't have to manually change it each time it changes ?

or maybe you mean that you want the same formula (that gives the same result) in a different cell ?

sorry for the questions, it didn't quite make sense what you wanted...