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.
<tbody>
</tbody>
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>