VBA Script not working as Expected

Hello,

For some reason the code below works, except for on the loop. I've included the workbook that I'm working on, the module name is WIP_Complete. It's supposed to subtract the quantity from the Item Master list from the quantity used in the Inventory Allocation tab for the respective component (e.g., Dried Hibiscus). I have it working except it gets the wrong output cell during the last loop. Rather than outputting in the correct cell, it does so 1 below and I have no idea why.


Here's the code:

Please Login or Register  to view this content.

Sorry, it should run when the item is marked as completed in the WIP tab.

So I think I got it working, but I'm not entirely sure how. I tried the same thing before, but now it seems to be working...magic, right?

This is the part that did it:

Please Login or Register  to view this content.