Ok yeah the duplicate I saw is now gone with that new code.
However - I have no idea how to edit that code to work with the realsample I attached this morning. I would like to match up 33 price classes, and input them into the appropriate columns like you have done. are you able to comment in the code 'this is where your price classes are matched
etc?
i'm so out to lunch with this unfortunately.
identicalness is defined by company address 1 actually, but when you added in company, the duplicate issue i found was gone.
edit - I can se like j,3 is taking from Company column, and.Item(sn(j, 32)) is the price class column.
if any combo of # is in there and matches, will it do what I want automatically?
I will want to put List price #1 in slot 1, list price #2 in slot 2, etc. - and do that type of sorting for all of my price classes as indicated in the price code attachment earlier too.