condoildate data and remove duplicates data

  • all files are located in same place
    macro will be placed in a seperate file
    plz have a look at the sample file and we are working with pink colour row data ignore rows that are not in pink colour
    file starting with update is a sample file and in that sample file there are duplicates also so first consolidate it and then remove duplicates and then keep only the contact no. of the customers to a new file and name the file todays date
    i have to do this by vba
    note: there are more than 2 files
    note: pink colour data may be in some file or cannot be in some file