PDA

View Full Version : Code to automatically add new email address to a table



Jetset
07-10-2013, 03:40 PM
Hi all,

I am completely new to VBA so I would be really grateful if you can write a code for me.

It should automatically add to the table “Input” (in File2) all the emails and date of receipt in File1 different from the ones already listed in this table. If more than one row in File1 has the same new email address, then it should copy to File2 only the most recent email.

In other words it should:

ADD A NEW ROW in the table “Input” (Spreadsheet2) copying:
- The “Email” value from File1 (B) to the new row in File2 (“Email” column, H)
- The “Date” value from File1 (A) to the new row in File2 (“Date” column, P)

ONLY IF
- The “Email” value from File1 (D2) is not equal to one of the emails address already listed in the column “Mail” (table “Input”, File 2). In case of more than one new email with the same address only the most recent should be reported.

REDO THE PROCESS until all the unique new email address are added to the table “Input” in File2

Please find attached File1 and File2 (dumb version) mentioned above.

Don’t hesitate to ask me any question if something is not clear.

Many thanks for your precious support!

Jetset
07-10-2013, 03:41 PM
Attached File2 mentioned above