ExcelBanter - Combining Text from multiple workbooks

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Combining Text from multiple workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/201777-combining-text-multiple-workbooks.html)

rwalrod

Combining Text from multiple workbooks

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

Sheeloo

Combining Text from multiple workbooks

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?

All times are GMT +1. The time now is 02:19 AM.