Hello Raph,

Q (1) If I replace the criteria list by another one, does it still work? I mean, same place but different length?

A (1) If the criteria remain in columns "A" and "B" on worksheet "Colorcodes" then nothing needs to be changed. You can keep adding on to the list.

Q (2) Is it possible to get an output where the color code is replaced by the name and if the code isn't findable in the list the output is the original?

A (2) Column "B" of the "Filenames" contains the converted file names. That is the color code number is replaced by the color code description. Column "A" contains the original file names.

Q (3) What are the sorting criteria for the output column?

A (3) I don't understand this question.