Is it possible to have a formula in one cell pass it’s results (text in this case) to update another cell?
If so, how?
thank you -
of course for Example, enter
=A1
into »other cell«
No, there is no way to pass any value (including text as in this case) to update another cell (without macro).
But you can get that value in the target cell. In the simplest case, this is a formula like =<original cell> or =IF(<original cell>="";"";<original cell>) .
Concrete example: suppose in cell B5 on the Data sheet you have the formula
=IF(AND(MONTH(TODAY())=12;DAY(TODAY())>24);"There is very little time left until the end of the year!";"")
You would like this text to appear on the Calendar sheet in cell D1. Just write in this cell =$Data.B2