I have a worksheet that I want to try and eliminate manual activity. To
simplify the question, assume I have three cells A1,B1 and C1. If the value
in C1 is X then I want to place the value of B1 in A1. If the value in C1 is
not X I want to leave the value in A1 alone.

I am trying to create a worksheet with YTD values and I want to place the
appropriate values in the appropriate month's columns. I don't want to
change the other values for other month's that have already been colleceted
and stored. It looks like I have a loop if I am trying to "pull" information
in A1. I can't figure out how to "push" information from another cell into
A1 without being in A1. Hope this makes sense.

Hi,

Not quite sure what you want but..

=IF(C1="X",B1,"something else")

or you could use VBA but we would need more to code that.
--
Cheers,
Shane Devenshire


"Smitty" wrote:

I have a worksheet that I want to try and eliminate manual activity. To
simplify the question, assume I have three cells A1,B1 and C1. If the value
in C1 is X then I want to place the value of B1 in A1. If the value in C1 is
not X I want to leave the value in A1 alone.

I am trying to create a worksheet with YTD values and I want to place the
appropriate values in the appropriate month's columns. I don't want to
change the other values for other month's that have already been colleceted
and stored. It looks like I have a loop if I am trying to "pull" information
in A1. I can't figure out how to "push" information from another cell into
A1 without being in A1. Hope this makes sense.

In your example, this command would be in cell A1. I don't wnat the value in
A1 to be changed if C1 contains anything other than X. If the value in C1 is
anything other than X, I want the contents in A1 to remain the same. I don't
want a o or FALSE to be placed into A1.

"ShaneDevenshire" wrote:

Hi,

Not quite sure what you want but..

=IF(C1="X",B1,"something else")

or you could use VBA but we would need more to code that.
--
Cheers,
Shane Devenshire


"Smitty" wrote:

I have a worksheet that I want to try and eliminate manual activity. To
simplify the question, assume I have three cells A1,B1 and C1. If the value
in C1 is X then I want to place the value of B1 in A1. If the value in C1 is
not X I want to leave the value in A1 alone.

I am trying to create a worksheet with YTD values and I want to place the
appropriate values in the appropriate month's columns. I don't want to
change the other values for other month's that have already been colleceted
and stored. It looks like I have a loop if I am trying to "pull" information
in A1. I can't figure out how to "push" information from another cell into
A1 without being in A1. Hope this makes sense.

I would say copy the current values of A1 to a helper column...say G then
enter this formula in A1 =IF(C1="X",B1,G1).

If you want, you can keep the column G hidden.

"Smitty" <Smitty @discussions.microsoft.com wrote in message
...
I have a worksheet that I want to try and eliminate manual activity. To
simplify the question, assume I have three cells A1,B1 and C1. If the
value
in C1 is X then I want to place the value of B1 in A1. If the value in C1
is
not X I want to leave the value in A1 alone.

I am trying to create a worksheet with YTD values and I want to place the
appropriate values in the appropriate month's columns. I don't want to
change the other values for other month's that have already been
colleceted
and stored. It looks like I have a loop if I am trying to "pull"
information
in A1. I can't figure out how to "push" information from another cell
into
A1 without being in A1. Hope this makes sense.

To leave or change data in A1 you must have a formula in A1 or use VBA to
achieve your ends.

Formulas cannot "push", only "pull"


Gord Dibben MS Excel MVP



On Wed, 23 Jan 2008 13:37:01 -0800, Smitty <Smitty @discussions.microsoft.com
wrote:

I have a worksheet that I want to try and eliminate manual activity. To
simplify the question, assume I have three cells A1,B1 and C1. If the value
in C1 is X then I want to place the value of B1 in A1. If the value in C1 is
not X I want to leave the value in A1 alone.

I am trying to create a worksheet with YTD values and I want to place the
appropriate values in the appropriate month's columns. I don't want to
change the other values for other month's that have already been colleceted
and stored. It looks like I have a loop if I am trying to "pull" information
in A1. I can't figure out how to "push" information from another cell into
A1 without being in A1. Hope this makes sense.