Hi all,

I have a worksheet with two lists on separate tabs... I need to get this list onto a third tab without duplicates... I also need it to be a formula or macro (not cut and paste) because it works off live data from my CRM system. I fundamentally understand how to do this but i can't seem to get it to work because the lists are formatted like this: Column A = Company, Column B = Contact...

I have attached an example of what i am talking about if this helps.

Fruit Companies Test.xlsx