Working with Odd and Even rows in coding

Hi xladept,
I need the code to read the value of the cell that the row is on top of the target row and 11 cells to the left 9of the target cell). Therefore the value in Leftcell4 should equal the value of the target cell minus 1 row 9up) and minus 11 columns (to the left).

I need that the missing part of the code to do the following: The code needs to use the leftcell4 value and offset 11 cells to the right and 1 cell down of leftcell4 and then insert the value of Currcell4.

Here is an example workbook with the code EXAMPLE.xlsm
The yellow boxes need to be all filled out automatically when any of the yellow boxes have value entered in it. My code is writing the value in the green boxes as opposed to the yellow.
So my goal is that if i enter a "Y" in the first yellow box i want the other yellow boxes to be filled out automatically. This code is working based off the matching "PO" numbers on column L.

Regards,
Kosherboy

I GOT IT!
See below blue font that i added to the code

Please Login or Register  to view this content.

Solved my own thread