right, so the purpose of this list is to have the part numbers that we are currently working on in this list with the full name (ex.1234-01). I also have a picture beside it so it is easily recognizable. The difference between 1234-01 and 1234-02 is very little and is barley noticeable in a picture. This is where the abbreviations come in.

In sort, Final product i will be hiding the abbreviated column at the end. I use a seperate macro to fill Column A with the full part name of the parts we are working on. If in this macro it could pull the abbreviated version into Column B based on Column A then pull the picture based on Column B that is end goal.