The entry is initially put onto the LineItems sheet when 'pending approval button' is selected and the save button is clicked (this code is located about 2/3 of the way down on the UserForm1 code page).

What I don't understand about the loop that I've been working on is that the ID numbers are already on the LineItem sheet if the invoice has been approved, so why isn't my code able to look through the LineItems sheet for the matching ID number and enter in the approval date and "approved" in the corresponding row? Even though there are multiple lines on the LineItems sheet with the same ID number, it should be able to step through and find them all, shouldn't it?