Create csv file using filter & duplicate function

Hi,

Every day I get master file and I need to extract email address from that file of each Code.Email address is extracted for each Code by removing duplicate address.I have attached the Master file which I get everyday and also I have attached the output file which I prepare.If I can get a CSV file using macro for each code then it will be of great help.

Right now I am using two methods to prepare file.First is using filter and by removing duplicating address and second I can prepare by using MS access.As the number of records are more than 50000 rows so I it takes around 20-30 minutes to prepare file.

Thanks in advance.

Loving

Yea your solution is working but as I said I don't want duplicate email address to appear under each name(TIM).

Hope you can modify it and give the solution.


Thanks