Harry Lee helped me with this awesome code but i need to make a little tweak. On the attached spreadsheet, the Part column C was populating on another spreadsheet. It works PERFECT! But, I had to change where we put the part number. It is now in column G, the Comments column. Long story why. :) I tried changing the code to look to column G, but then the "Order Total" showed up on the SOImport spreadsheet. Before i made that change, that didn't happen. So obviously there is something that says take all the parts, put them on the SOImport spreadsheet, but don't include the "Order Total" line. I just don't know where that is. Could I get some help with that? I attached the SO showing the change.