Excel - send result of formula to another cel

Closed
Ajay - Oct 22, 2009 at 10:19 AM
 Penguin Duvel - Nov 11, 2009 at 10:19 AM
Hello,
Is it possible to have the results of a formula go to a cell other than the cell containing the formula?

And I don't want to do the '=c5' type thing. That's the wrong way round (that's another cell requsting the data from the forumla cell. I need the formula cell to pro-actively send the results to the other cell, so the other cell can contain the actual data)

This is so that if someone does ctrl-c on the cell and they copy the value rather than the formula.
Related:

5 replies

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Oct 22, 2009 at 10:20 PM
the question is not clear
if in any cell if you type A1+B1 it will give that result.

more clarification is required.
2