Macro to check a list of emails matches in two different tables

Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel developer currently at the post of Forum Expert at www.excelforum.com. I checked the attached file. I can help you separate the addresses to whom mails are sent but not opened and your private contacts as you mentioned. I can begin right now. I look forward to a positive and prompt response from your side. Regards Sourabh

I am expert in Microsoft Office specially Excel, Word and Access Database. Data Entry and Processing is my passion with years of experiences. I am talented and very hard working also know the value of time so, always try to deliver work on time. You can check our company profile for customer services and customer satisfaction. Our motive is to make our employer happy with quality of service. For data entry work, we promise to deliver you the best of best services.

Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

Dear client I understand the two requirements you mentioned in the project brief. I can write macros to achieve them. Please contact me. Roy

I can do it for you quickly and exactly .Please contact me for saving your time and your moneys .

Greetings! I have reviewed your requirements and understand the same. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. Please share the files (file with the list of emails of the ones that have opened and file with the list of your own contact) - I would update as required. I have 20 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 200 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Merry Christmas! Have a Great Day! Srinivasan Krishnamoorthi

Hi, I have understand the project requirement & interested to work for this project. I will start right now. Please send a message so we can discuss more & start the project. Thanks.

Hello, I would like to work on your project. I have great experience using excel macros / vba, data formatting and data manipulation in excel, working with multiple files, transferring data with / without changing data format. I am confident that I can write macros to extract emails and doing comparison between 2 files with 100% accuracy. Let's discuss further details on chat. Regards.

I am MBA accounts and finance, Mphill in computer science and having seven years of experience in Excel (vba & macro's) development. I already done many projects of: • Excel Automation. • Excel Reports system. • Excel financial models. • Power Bi dashboards. • Excel dashboard designing. • Excel Solver. • Microsoft Access. • Excel calculators. • Excel vba. • Excel Tracker. • Excel macro's. • Visualizations, Chart's, Table's. • word macro's. I have ability to do your project within your deadline, I need some discussion to make the things clear. Thanks.

Hi, I can write a macro to create a list of non opener emails. I am experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra

Hi, I went through the Excel file. Based on the LastOpen can get the list of the email ids of people who have not opened your email. Again based on the other sheet you have who are on your private list , can identify those people from this file. Can be done in a day. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl

Hi, I am an Australian-based software developer with significant experience in Excel VBA coding. The task you have is a simple one that should be achieved in only a number of hours...therefore I would not charge more than the above cost in total. I will use a simple algorithm to extract the emails that have no value in column B (last opened) as it appears that this is the only thing in the attached CSV that would indicate which emails you are wanting to filter out (although I can adjust this based on what you specify). For the second part, I can include an algorithm that will enable you to select a file to open and compare that list as well The output will be a separate CSV file that will simply contain the emails of: All people in the list in Column A, the people who have not opened the email yet in column B, and the ones who are in your private contacts file in Column C. Please feel free to Private Message me with any questions that you might have.

I can definitely help you with that. I am a professional Data analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro to perform automation and create highly dynamic and automated dashboards. I will be happy to discuss in detail how I am highly suitable for this project.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Hi! here is Muhammad, i reviewed project description but i have some important question's related to project, Can we discuss right now. For more details please review my profile https://www.freelancer.com/u/raoasghar Looking forward to hear from you.

Hi, I can write macro for you in which you will have 4 sheets. sheets one will be the setting (so you are able to choose to extract which emails should be extracted based on which criteria). And also you will have a run button. on the two other sheets, you can copy paste the All the (current attached Excel table) and in the other one you can copy past your second data. When you press run button in setting, the macro will iterate through each item if first raw data and copy the data if its match with your criteria and then it will past it into the last 4th sheet. Please send me message to discuss more.

Hi, I did a lot of projects about writing a macro to compare data in separate files (CSV, text, excel files,....)in an efficient way I have rich experience in excel (Advanced formulas, Charts, Forms, VBA, Macro,....), and I do my best to save your time and pocket. Please feel free to contact me. Services: # Accuracy # Customer satisfaction is my first "Priority" # Time Commitment # Availability Thanks, Shahin

Hello Sir, I can extract unopened email list and also the personal contact form Excel files. I can do it using macro or formulas for accurate results. Let's discuss with me for further process. Regards Faizan

Hi, this data extraction, exlcusion, highlighting....can be done in your file. I have the required experience in EXCEL. Will return the worked out file on the same day I have good rating with my clients

Hello, I've read your project requirements thoroughly. It's quite an easy task and I have experience with Excel VBA and Macros. It will be quick and accurate. If interested, we can discuss this further on chat.

Dear, I am an Excel professional having hands on expertise on data analysis and management I will do your project as per your requirement. Best regards HUMAYOON