Hi All,

Somehow I want to enter a formula in cell A2 and I want cell A1 come up with
a number as a result of the formula entered in A2. Is there any way to do
this?

I don't want to enter a formula on A1 such as =if(A2=blah blah, correct,
incorrect). I am planning to read from A1 so, I don't want to enter a formula
there instead I want this cell be impacted by another cell. Something like a
report cell.

Please let me know if this is possible.
Thanks in advance

Erol,

Formula cannot 'push' data, they can pull data so without a formula in A1 it
isn't possible to do what you want without resorting to code.

If you explain with more detail what you want then someone will help.

Mike

"Erol" wrote:

Hi All,

Somehow I want to enter a formula in cell A2 and I want cell A1 come up with
a number as a result of the formula entered in A2. Is there any way to do
this?

I don't want to enter a formula on A1 such as =if(A2=blah blah, correct,
incorrect). I am planning to read from A1 so, I don't want to enter a formula
there instead I want this cell be impacted by another cell. Something like a
report cell.

Please let me know if this is possible.
Thanks in advance

Yes it is possible.

You would create a event macro that would monitor the formula in A2 and,
depending upon the result, change the contents of A1.
--
Gary''s Student - gsnu200851


"Erol" wrote:

Hi All,

Somehow I want to enter a formula in cell A2 and I want cell A1 come up with
a number as a result of the formula entered in A2. Is there any way to do
this?

I don't want to enter a formula on A1 such as =if(A2=blah blah, correct,
incorrect). I am planning to read from A1 so, I don't want to enter a formula
there instead I want this cell be impacted by another cell. Something like a
report cell.

Please let me know if this is possible.
Thanks in advance

Thanks for the replies. I don't know how to create a event macro. Could you
walk me through it. Where do I find the button for event macro? In which tool
bar is it in?

Thanks

"Gary''s Student" wrote:

Yes it is possible.

You would create a event macro that would monitor the formula in A2 and,
depending upon the result, change the contents of A1.
--
Gary''s Student - gsnu200851


"Erol" wrote:

Hi All,

Somehow I want to enter a formula in cell A2 and I want cell A1 come up with
a number as a result of the formula entered in A2. Is there any way to do
this?

I don't want to enter a formula on A1 such as =if(A2=blah blah, correct,
incorrect). I am planning to read from A1 so, I don't want to enter a formula
there instead I want this cell be impacted by another cell. Something like a
report cell.

Please let me know if this is possible.
Thanks in advance

Because it is worksheet event code, it is very easy to install and use:

1. right-click the tab name near the bottom of the window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To remove the macro:

1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

To learn more about Event Macros (worksheet code), see:

http://www.mvps.org/dmcritchie/excel/event.htm

If you need help in writing the macro, just update this post.
--
Gary''s Student - gsnu200851


"Erol" wrote:

Thanks for the replies. I don't know how to create a event macro. Could you
walk me through it. Where do I find the button for event macro? In which tool
bar is it in?

Thanks

"Gary''s Student" wrote:

Yes it is possible.

You would create a event macro that would monitor the formula in A2 and,
depending upon the result, change the contents of A1.
--
Gary''s Student - gsnu200851


"Erol" wrote:

Hi All,

Somehow I want to enter a formula in cell A2 and I want cell A1 come up with
a number as a result of the formula entered in A2. Is there any way to do
this?

I don't want to enter a formula on A1 such as =if(A2=blah blah, correct,
incorrect). I am planning to read from A1 so, I don't want to enter a formula
there instead I want this cell be impacted by another cell. Something like a
report cell.

Please let me know if this is possible.
Thanks in advance