Hi Dfak,

Perfect!! The idea is correct and everything works,

however, many are coming up as no directory as Column A has part number "1002690-305" for example and instead it should read "1002690_305". similar with column C it reads "1002690305" and it should read "12690305" (removing the second and third character)

where does the parts list table come from? copy and paste from Routing? If so could we put a replace function in for - * _, and also column C to remove the 2nd and third character?

Cheers