The spreadsheets I receive from the supplier have added some new colors for all their products but they are all several lines down from the original colors and I need them all together.
Example: The product ID’s and names are like this one:
Product ID: 51-05 LGAQ
Product name: Birthday Boy Shirts Aqua Lg (14)
The lines for that product are from 1383 thru 1424 and then from 27468 through 27481.