Thank you for the update. I revised the summary a bit to fit my bosses needs, but ran into an issue when I tried my first order. Basically some job #s have length quantities greater than 1, so I broke out the quantity into duplicate rows (ie Qty 2 of length 6071 would break out into 2 rows of 6071). Therefore if I delete the code that removes duplicates it would work. Is there any harm in removing that section?:
Also, in the attached file, I ran the code with the job #. Is there any easy way to group the 'order combination' tab so that duplicate order combinations & job#s show up as one light with a quantity?