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
Bookmarks