The attached apeople excel file contains the email address and branch names.
1. I have to filter each branch name and save it in a new excel file.
2. I have to send the excel file saved in step 1, whichever e-mail address is in front of the branch in the Apeople excel file.
How can I do it? I will do this for 800k rows. I dont know how to do it in macro.
Hi @rojda dilan küpeli ,
Best Approach here is to use Excel as a Database, Checkout below links to get more insights on implementation.