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.

XXX	123		ABC	1
			DEF	2
			GHI	3
			JKL	4
			XXX	123
			MNO	5
			PQR	6
			STU	7
			VWZ	8

<tbody>
</tbody>

 

[Fluff]

You're welcome & thanks for the feedback