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?

 

[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

Is it possible to reference excel formulas in the VBA macro? For example, the =indirect formula?