Comparing Worksheets
Posted by Clay on October 18, 2001 10:29 AM
I have two worksheets consisting of customer listings from 2 different companies which have similar columns (Account Number, Name, Address, City, State and Zip). The problem is that the Account Numbers are different for each company and the customer listing is larger for one company. What I need to do is compare the 2 worksheets, find the similar customers and then be able to show both Account Numbers side by side. Is this possible? Thanks for any help.