Hi all,

I have code here, by worksheet change. i want to copy if

L8 = OK >> copy D8:F8 to M8:O8
L9 = OK >> copy D9:F9 to M9:O9
L10 = OK >> copy D10:F10 to M10:O10
.
.
.
.

until L17 = OK >> copy D17:F17 to M17:O17

right now I'm writing it one by one like this below...

any advice to do it in more neat & shorter code?

thanks a lot for the help
warm regards

Adrian


Please Login or Register  to view this content.