replace all data in cell (insert cell) with data in cell (insert cell).

[JustinEP]

Having trouble figuring this one out:

I want to put a formula in cell A1 that says: replace all data in cell C1 with data in cell B1.

If it cannot be done with a formula, could someone help with a macro?

 

[SteveO59L]

Cant be done, with a formula. How would you like to trigger this event?

 

[JustinEP]

Cant be done, with a formula. How would you like to trigger this event?

Maybe a small button. Even just entering the value and pressing enter would be fine. I will have approximately 30 fields that I would want to update, some may need updating, others won't. Some will be simple yes or no choices, could those still use a list and be triggered with just clicking out of the cell?

Also, if there was no value added to the new cell, I would not want that blank value to update the original cell.

Thank you very much!

 

[SteveO59L]

So, if you enter a new value in any cell in col A, you want the corresponding cell in col C populated with the corresponding value from col B ?

Is that correct ?

 

[JustinEP]

So, if you enter a new value in any cell in col A, you want the corresponding cell in col C populated with the corresponding value from col B ?

Is that correct ?

It is actually more like this:

http://www.mrexcel.com/forum/showthread.php?t=576504

I don't know how clear that post is, I am having trouble describing what I am trying to accomplish.

 

[SteveO59L]

Sorry, thats as clear as mud.

 

[JustinEP]

Sorry, thats as clear as mud.

No problem, sorry about that.

I have data in column B1:B10. I want to be able to put a new value in C1:C10 that will trigger replacing the data in B1:B10.

 

[JustinEP]

Sorry, thats as clear as mud.

I can e-mail you the sample sheet if you would like.

 

[SteveO59L]

If Target.Column = 3 And Target.Row < 11 Then
Target.Offset(0, -1).Value = Target.Value
End If

upon changing a value in c1:c10, copy that value to corresponding row in col B

 

[JustinEP]

If Target.Column = 3 And Target.Row < 11 Then
Target.Offset(0, -1).Value = Target.Value
End If

upon changing a value in c1:c10, copy that value to corresponding row in col B

That looks awesome. Do you mind if I complicate this further?

The value in B1 is =indirect(A1). A1 contains =text("Sheet2!K1",""). How would I send the new data in C back to Sheet2:K1, where the actual data in B is located?