Thank you so much for the reply, I was not able to work  on this for a
few days, so I did not have a chance to try it out.
I tried it and it nearly worked.
It was making the wrong column  into negative, so based on your
explanation I changed (target.column - 5)to be (target.column - 6)and
it worked. Thank you so much!

I dont yet fully understand how this works, so I have another similar
question.
Is there a way to do this for every 18th column (For a different
worksheet)?