Hello,

I need a VBA which will automatically create a new CSV file from the old one (attached) based on this criteria:

Update column email with domain @abc.com Email format: first letter from name and full surname, lowercase. Equal emails should contain location_id before the @.

Example:

Now:       8,6,Bart Charlow,Executive Director,,
               9,7,Bart Charlow,Executive Director,,

Need to be: image attached

​Hello, I need a VBA which will automatically create a new CSV file from the old one (attached) based on this criteria:Update column email with domain @abc.com Email format: first letter from name and full surname, lowercase. Equal emails should contain location_id before the @. Example:Now:       8,6,Bart Charlow,Executive Director,,               9,7,Bart Charlow,Executive Director,, Need to be: image attached  Read More

​