Unfortunately I've already purged the test data I had for this. However, all is not lost. I'll need to ask some more questions.

The part of the code you pointed out adds a "-1" to the expected directory name if the last three digits of the part number in column A are even. The part that tests for the existence of the directory comes a couple of rows later.

So now you are telling me that the directory name could be 1002690-305 or it could be 12690305 or in the case of an even number: 1002690-306-1 or 12690306-1.

If this is the case, then I'll have to add a bit of code between the two pieces of existing code to test if either of these directory names exist and use the proper one. I'll push on in this direction.