Two Simple Excel Macros - VBA Needed
$50-400 USD
Pago na entrega
*** I will provide files once the project is awarded ***
Objective & Scope:
We are looking to get two Excel Marco created where we can clean up and deduplicate a data list and then export them into a tab-delimited files, the second macro will be simply cleaning and merging worksheets together.
First Macro First Function:
Ref: Emails to [login to view URL]
We need to take an Excel CSV File and strip out the email addresses to generate one single tab delimited text file
We would like to have this workbook when it is first to open have a function to browse for the file where the user can select the file that needs to be cleaned up:
Step 1: Copy email addresses and First Name in Column “O” and Column “A” into a new worksheet
Step 2: Append the email addresses in Column “AD” and also First Name Column “P”
Step 3: Remove Rows that contain Amazon & Walmart
• @[login to view URL]
• @[login to view URL]
Step 4: Remove and purge any duplicates
Step 5: Sort the email address and First Name by A-Z
Step 6: Save out tab delimited text files with email addresses and first names in text files
Email addresses beginning with
0-C – Goes in List 1
D-F Goes in List 2
G-J Goes in List 3
K-m Goes in List 4
N-R Goes in List 5
S-Z Goes in List 6
The files can simply be saved as “List [login to view URL]” “List [login to view URL]” et al
Second Marco
We are looking to get an that will merge email addresses down into one main tab delimited text file. Ideally, we would like for a prompt on each of the files or we could have a file path location where to put the files into for a certain folder.
Ref Files:
DO NOT MAIL - email ist (version 1)(New).xls
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
** Finished File Example [login to view URL]
Basically, here we are looking to strip out all the email addresses in these five files and merge them into one master tab delimited text file named “[login to view URL]”
Email Address Columns:
DO NOT MAIL - email ist (version 1)(New).xls – Column A
[login to view URL] – Column C
[login to view URL] – Column C
[login to view URL] – Column B
[login to view URL] – Column B
ID do Projeto: #18657936
Sobre o projeto
Concedido a:
Hi, I was hoping that you contact me directly for new tasks :) I m here if you want. Thanks ***************************************************
12 freelancers estão ofertando em média $206 nesse trabalho
Hello , I have read your project description and i can write these 2 macros(i need some clarification on second macro). As you explained in brief i will write first macro to follow 6 given steps and spli Mais
Hi, Your work brief specified below. You can check. I will do this without using Macro. Is it okay? Hope, it is your project. Could you give a chance to work your project? Thank you so much!
Hi, As per requirements I will develop VBA macro for you which will process the data as per description of the project. Please share your Excel sheet. I have expertise in Excel, formulas, Excel VBA and finished many Mais
Having an MBA, what better can you get. You can give me this task as i have requisite qualification and experience. You will be happy to see my work. Looking forward to work with you. I have many business plans, a boo Mais
Hi I am an engineer experienced in using excel vba for creating custom functions and analysis data in existing csv , excel files. I can create you these two macros to process existing excel files. Thanks Note-pleas Mais
Hi, I have gone through your project specification and found it doable. I am an Excel Expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Thank you Awaiting Mais
Hello, Hope you are doing well. I can help you in your project About me & what I can provide - • 5 Yrs. of Experience in EXCEL & VBA. • Knowledge of FORMATTING, PIVOT, SLICER, GRAPHS, CHART & FORMULAS. • Macro c Mais
"""I have checked what u need please see my certified tests Let us discuss in chat to start it happy to speak with u thanks sadek"""
I hope you are doing great.I have read your project description very carefully .I always maintain long term relation with my clients. I can do the project perfectly, If you want perfect project please contact me.