Allow no action to be taken
 

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.

Allow no action to be taken
 

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.

Allow no action to be taken
 

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.

Allow no action to be taken
 

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.

Allow no action to be taken
 

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.