After looking at this for a few hours lol. I think I'm following it. Is this the line of code that pastes in the data?

.Cells(writeRow, 1).Resize(1, 4).Value = fndNum.Offset(0, 2).Resize(1, 4).Value

It looks like it grabs all of the data right of the Offset. It needs to be very specific on what is copied. There is other info in the real log to the right that doesn't go into the form. If the Transfer Number is XX00002345 then the copied data needs to be specifically C4:F4.

Learning a lot. Thanks in advance