0 Replies Latest reply on Nov 21, 2018 1:27 AM by Robert Voogt

    Add description value from pdm to list of article names in excel

    Robert Voogt

      Hi all,

       

      I have a list of certain parts (equal to the article number column in pdm) in an excel file  (Column A). I need a macro (vba) that searches for the article number and then add the value of the description column of pdm in Column B (in caps).

       

      So that I have all artikel numbers in A and their respective descriptions in column B.:

       

      | DF00037412 | BOLT |

       

      Is this possible?

       

      Description is the 2nd column in our pdm and the article number is in the 3rd column.