PartNumber.jpg

Hi,

I am trying to create a part number generator from multiple drop down lists.
6 drop down lists are individually selected to generate a part number, the part number is comprised of the letters in the column REF CODE.

I will let the attached image do the explaining, it has an example code to show what im aiming for. thanks in advance for any help