That's true I did not notice it, but like you say, some dashes, extra spaces etc. I think we could go through that and make them all the same. Do you propose a sem-automatic way of doing it? I noticed in snb's code he had "- " to "-", etc.

Assuming everything is the exact same, then we can find matches.

There are only a few accounts that will need all 14, and the order is not of any importance, just need them to go into 1 slot, assuming start at 1 and if empty, put it in, etc.

The last 3 digits are ship-to accounts. So sometimes you can have 123456-001,002,003. 001,002,003 are usually different addresses.

100424-002 company ABC 2300 EGLINTON AVE W STE 401
100424-003 company ABC 515 PARK RD N UNIT # 3


edit - also just checked more data, and more of them seem to be exact matches than not, so it may not be a huge issue (I realize it still is one).


Quote Originally Posted by mperrah View Post
re post #25 from snb,
his code worked for me, quite elegant.
data output to sheet2, added a fix for extra spaces throughout the address list,
added columns to the right and has the duplicate company items added there. nice work

about the error, be sure you have a sheet named "Sheet2" maybe
Yeah I had to re-open it, something messed up when I opened and saved. I replied with post #26, it is great, except not all on one line, like the comment you are inquiring about. (importance of which account goes into which slot of list price 1-14)