Need help merging on three columns

Hi bajjan,

There's quite a few duplicate customer names - how do you want to handle them?

Hi bajjan,

Here's an UDT and Merge Routine - I've left the duplicates in place - I've left the result in storage - Did you want the results on either sheet or in a separate book?

Please Login or Register  to view this content.

Here's the code and the Instructor Book with the code in it:

Please Login or Register  to view this content.

Hochstein.xls

Hi Bajjan,

I had second thoughts and it revealed 13 extra records - I decided to make it be a real merge, which is what you asked for and it runs quickly and thoroughly so replace the last code with this:

Please Login or Register  to view this content.

I sent you the Workbook with code in the module - just download that book and replace the code (all of it) with the last version - then, using that book and the transaction book run the code - it will produce the merged records in key order.

Hi bajjan,

You're welcome - but here is a better version:

Instructor by city Hochstein.xls

Do you want something different than my previous post?