Copy cell value based on another cell value criteria

[nuficek]

Hi,

could anybody help me please with VBA code to copy value based on another cell value. I have a table where I put data in the column "E". If the value in the cell "EZ" is the same as value in the "B1" I need to copy value from "C1" to "FZ". I need to run the code anytime when the value is inserted and criteria met. Any help would be appreciated.

[TABLE="width: 500"]
<tbody>[TR]
[TD]XXX[/TD]
[TD]123[/TD]
[TD][/TD]
[TD]ABC[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]DEF[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GHI[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]JKL[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]XXX[/TD]
[TD]123[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]MNO[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]PQR[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]STU[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]VWZ[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

You're welcome & thanks for the feedback