Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

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.

Thanks

Re: Copying values, not formulas, via a formula

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

Re: Copying values, not formulas, via a formula

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

Re: Copying values, not formulas, via a formula

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
:-)

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.