Hi All,

I want am working on a project that we have just handed over to a client. all parts have my companies part number but the client wants us to assign each part their part number - there are over 1000 parts and drawings and its in the PDM system.

Ideally I would like to line up our part numbers and their part numbers in excel and use some code to change them over.

I am also open to any other methods.