Excel: Append Unique Data

I have a question that I am sure is not unique. I have one Workbook with a column of data in Sheet1 and a column of data in Sheet2. The column on Sheet1 is my master customer list. Most customers are repeat customers but each month we get a few new customers. I show the current month sales on Sheet2. I want to compare the list on Sheet1 with the list on Sheet2. If there are names on Sheet2 that do not appear on Sheet1, I want to add those customer names to the bottom of the list on Sheet1. Any help would be appreciated. Thanks, Ed Stockton

This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of August 06, 2014.

For more resources for Microsoft Excel