I have 5 address books saved onto separate spreadsheets and I would like to put them all together to make a master Address book. I would need to find any duplicates and remove them to a separate sheet to remove them from each address book so they essentially all match in the end.
Where do I start?
Just learning Excel so please Dumb it down for me!
Combining 5 workbooks into one and removing duplicates