Write data from one cell to another cell
 

Write data from one cell to another cell

Is there any way to SEND data from one cell to another?

I wish to use a nested IF function in one cell to choose between three
different criteria, in the event 1 then output A, event 2 then output B, Etc.
However I want the three different outputs to go to three different cells. Is
there any way that I can write the result of a formula in one cell to appear
in another (say the formula is in cell A1, but I want the output to appear in
either B1, B2 or B3 depending upon the output of the formula).

I know that this could be done by using a second IF function in each of the
€˜receiving cells (i.e. B1..B3) but I am looking for a solution where I can
leave the cells B1..B3 blank and only have data appear in them after cell A1
has performed its function.

Comments:
I am looking for a solution that does not require the use of either VBA or
macros. I am using Excel 2007. Also please include any relevant information
about cell formating Etc.

Many thanks.

Write data from one cell to another cell
 

Your choices for entering data or having things "happen" in Excel a

1) Formulas
2) Macros (VBA)

You've eliminated both options in your description of the goal.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61552