Requirement is not clear.

Simples way is to select all rows in one sheet and paste below the last row
in the other sheet...

Do you want to remove duplicates after merging?


"rwalrod" wrote:

If I have 2 workbooks each listing 20 customer names, can I create a 3rd
workbook that will combine the lists?