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!
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!