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

Hi

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.

Thanks


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.

HTH


Ivan

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.

Thanks

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...

Chris
:-)