excel Marcos

the 2 file attached must be merged but before doing this you need to fix somthing inside as follow: 1) first cleaning and adjusting operation in file cerved [login to view URL] - find in the column P and Q all cells not containing valid e-mail and delete the content - copy all mail in column Q in empty cells of column P - delete column Q - in column R named telefono add a 0 (zero) before any numbers -in column O (Sito web) http:\\www.(domain name) you find in e-mail adress (avoid to do this domain as gmail libero tin icloud - in column L (fatturato) delete data in cells not correctly formatted and left only the one with written "number-number mln" - in column K (Dipendenti) delete data in cells not correctly formatted and left only the one with written "number-number" or "number" now you can merge the file with the second one called "aziende [login to view URL]" than you have to create a macro on this file able to catch e-mail adres from csv file and put it in the right row near the "sito web" cell ... to do this im sending you example of csv file will use to import e-mail adress time to time.... (1-5000 [login to view URL]) please note that some url have more that one e-mail adress like [login to view URL], in this case i wish that more raw will be added in destination file reporting all company data and next mail.