Return text to cell other than the one with the formula in it?

#1 February 25th, 2004, 05:11 PM

Is there a way to return text to a designated cell other than the one with the formula in it? If I put a formula in a cell on sheet B to return text to a cell in sheet A with certain criteria to meet before inserting the text. Any help greatly appreciated.

#2 February 25th, 2004, 05:19 PM

=IF(A110,"text","")

--

Regards,

Peo Sjoblom

"Jason" wrote in message
...
Is there a way to return text to a designated cell other than the one with
the formula in it? If I put a formula in a cell on sheet B to return text to
a cell in sheet A with certain criteria to meet before inserting the text.
Any help greatly appreciated.

#3 February 25th, 2004, 05:41 PM

So, if I have an if function in cell A1 sheet B, but wish to send that information that it returns to cell A1 of sheet A without putting that formula in cell A1 sheet A? Is there a send to function or something similar.

#4 February 25th, 2004, 06:07 PM

Hi Jason
this is only possible with VBA (e.g. using the worksheet change event)
but not with formulas. In your case I would enter the formula Peo
provided to you in cell A1 sheet A

--
Regards
Frank Kabel
Frankfurt, Germany

Jason wrote:
So, if I have an if function in cell A1 sheet B, but wish to send
that information that it returns to cell A1 of sheet A without
putting that formula in cell A1 sheet A? Is there a send to function
or something similar.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode