Write data from one cell to another cell

  • Thread starter Thread starter Highbury 1
  • Start date Start date
H

Highbury 1

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
macro’s. I am using Excel 2007. Also please include any relevant information
about cell formating Etc.

Many thanks.
 
Hi
Formula can only pull information,can't push info to other cells.
Your only solution is VBA.
HTH
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Cell entry 2
Copy Excel functions formula and auto refresh refresh 3
check data from different cells 1
Excel Linking Multiple cells to One cell for Results 0
Excel In Excel how can I block the contenent of a cell? 0
Comparison of columns using Conditional Formatting 3
can a cell be both input and output? 2

Back
Top