Appending unique data from one worksheet to existing data on another worksheet
Hello,
I have a problem that is not unique I am sure.
I have a master list of customers. Most of our sales are repeat customers. However, we do get new customers each month.
I have a master list of customers that I would like to append with new customers. Sheet1 represents our master list. Sheet2 is sales to customers last month. I want to find unique names that appear on Sheet2 that are not on Sheet1 and append those names to the list on Sheet1.
I would appreciate any help.
Thanks, EdStockotn
Last edited by EdStockton; 08-06-2014 at 12:16 PM.
Reason: Need to attach sample data
|