MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Copy Value produced by formula in cell C3 to cell D3

  Asked By: Pedro    Date: Feb 22    Category: MS Office    Views: 1313

My question shouldn't require VBA, just a greater knowledge of Excel
itself than I possess:

I can't believe I can't figure out how to do this one on my own. It's
got to be pretty basic. I have a formula in C3. I want cell D3 to
contain the value produced by the formula in C3.

I can do it with "copy" and "paste special", and then "values", but I
would like to set it up as a function in D3 so that I can just
autofill all of row 3 down from project to project.

It must be possible to do this, isn't it? I have a reply from another
forum that indicated VBA may be required. If that is so, I will need
to rethink the entire spreadsheet, and attempt a VBA routine to do
what I am currently doing with functions elsewhere in the worksheet.
Before I go that route, I thought I'd get a second opinion, hopefully,
from this forum.



7 Answers Found

Answer #1    Answered By: Kathleen Adams     Answered On: Feb 22

How about putting the formula  "=C3" in cell  D3?

Answer #2    Answered By: Dixie Jacobs     Answered On: Feb 22

Thank you. That's the first thing I tried, but for some reason or
other, it gave me an error flag, and the results did not sort as I
would have expected.

Answer #3    Answered By: Saiqa Mian     Answered On: Feb 22

I found this page for you.

Probably this is what you want to do:


Answer #4    Answered By: Fareess Khan     Answered On: Feb 22

I'm only seeing one message at a time here; I'm used to seeing the
entire thread. I hope yours is the message I haven't replied to yet.
I want to make sure I thank everyone for their input.

Two of the replies, including yours, suggested something similar, and
although I haven't had a chance to try the suggestion, I'm pretty
confident that you have given me what I needed.

Answer #5    Answered By: Luann Schmidt     Answered On: Feb 22

Try this:

A1= 21+69+89+25+31
A2= 21*25
A3= 100/10
A4= 100/10*(10*10+10)
A5= 100/10*10*10+10

without the "=" sign.

1) Select cell  B1
2) Go to Insert>Name>Define
3) Type the name Result (can be any valid range name)
4) In the Refers to: box type: =EVALUATE($A1)
5) Click Add then OK.

Very important to select cell B1 and use a Relative Row reference for
6) Simply enter =Result into cell B1 and copy  it down.

Answer #6    Answered By: Garritt Bakker     Answered On: Feb 22

I'll give it a try...................

Answer #7    Answered By: Cameron Smith     Answered On: Feb 22

First, Sorting the single column only sorts the formulas and with
relative references, the formulas always refer to the unsorted cells.
It might help if you told us what your ultimate goal for the values
is. THere may be a way to accomplish your final goal without a macro.

You clearly want the *value* in the cell  and not another formula,
right? Your PasteSpecial>Values is what you want, but any formula  you
put in a cell remains a formula and the result is normally shown.

I believe this is not possible (automatically) without VBA.
This is s simple macro. Simply turn on the Macro recorder
(Tools > Macro) and pick a name (no spaces, use _ ), then do the
PasteSpecial>Values thing on the cells or column you want, then stop
the Macro recorder.
To run it Tools > Macro > Macros Select your Macro name.

If you want to see the code go into the VB Editor ((Tools>Macro).
You can eventually assign this Macro to a button right on the sheet
that will run the macro.

Didn't find what you were looking for? Find more on Copy Value produced by formula in cell C3 to cell D3 Or get search suggestion and latest updates.