Hi,
I work on mostly excel and my job is to play around with the data. Basically i work as admin assistant and looking for an VBA excel macro for correcting wrong email ids and replacing them with the correct email IDs, also need to insert a comment against the corrected email id cell as "corrected from XXXXXX@company.com to XXXXXX@abcd.com" (this is an example). Each day i need to correct 100+ email ids in an excel file by using VLOKUP function with the main source file and manually insert comments individually. This has been a hectic process for me, so can some one help with the VBA Macro to run this process automatically? Pls pls pls help
Regards,
Satya
I work on mostly excel and my job is to play around with the data. Basically i work as admin assistant and looking for an VBA excel macro for correcting wrong email ids and replacing them with the correct email IDs, also need to insert a comment against the corrected email id cell as "corrected from XXXXXX@company.com to XXXXXX@abcd.com" (this is an example). Each day i need to correct 100+ email ids in an excel file by using VLOKUP function with the main source file and manually insert comments individually. This has been a hectic process for me, so can some one help with the VBA Macro to run this process automatically? Pls pls pls help
Regards,
Satya