The attached workbook contains two lists of customers:last year purchasers company last and this year purchasers
I want to write a sub that captures the existing lists in two arrays and then creates three new arrays:
1) One with customers who purchased last year only
2) One with customers who purchased this year only
3) One with customers who purchased in both years.
After these new arrays have been filled, need to write their contents in columns D, E and F of the worksheet.