I have a sheet that has a table with these two columns:
Column A: SKU Number (ABC, DEF, etc)
Column B: SKU Description (irrelevant)
I want for each SKU number in this sheet (so we need to check all the SKU's here and stop whenever we are out of values), to copy the SKU with two predefined rows of values in another sheet that has these columns:
Where the SKU Number in the other sheet would be populated into the PRINTER_PROD_NBR column for these two rows that will have to have the same exact values for each SKU in this sheet. So kind of 2 rows for each SKU copied all over again for each SKU until we get to the end of the list. Columns MONO_YIELD through CP_PAGE inclusive can be blank, no issue there.