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.