Completed

Two Simple Excel Macros - VBA Needed

*** 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

Skills: Data Processing, Excel, PHP, Visual Basic, Visual Basic for Apps

See more: useful vba codes for excel, excel vba programming for dummies, excel macro examples, excel macro tutorial pdf, vba excel download, macros in excel for beginners, excel macros for dummies, excel macro tutorial for beginners, simple excel vba, simple excel vba open external program, freelancer excel macros vba, simple excel vba script, converting excel macros vba access, excel macros scripting vba tutorial, add references excel macros vba, simple optimization algorithm vba excel, simple excel vba sample, extracting xml data using vba excel macros, freelance excel macros vba, job freelance excel macros vba

About the Employer:
( 87 reviews ) Richmond, United States

Project ID: #18657936

Awarded to:

bouslimi1979

Hi, I was hoping that you contact me directly for new tasks :) I m here if you want. Thanks ***************************************************

$200 USD in 3 days
(280 Reviews)
7.6

12 freelancers are bidding on average $206 for this job

SBITServices

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 More

$100 USD in 3 days
(426 Reviews)
7.4
Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m More

$300 USD in 2 days
(195 Reviews)
6.7
paulmd369

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!

$400 USD in 10 days
(111 Reviews)
6.4
TechnoGuruu

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 More

$250 USD in 5 days
(60 Reviews)
5.4
sloker18

I am proficient with Microsoft Excel and marco/VBA development. I read your project descriptions carefully, I can write the marco to extract/clean up email addresses as requested. You’re welcome to checkout my rev More

$150 USD in 3 days
(65 Reviews)
5.4
ahmedashraf105

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 More

$300 USD in 10 days
(7 Reviews)
4.4
sambestsolutions

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 More

$250 USD in 4 days
(20 Reviews)
4.3
prasannjeetp

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 More

$150 USD in 5 days
(43 Reviews)
4.5
srijanagrawal21

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 More

$70 USD in 3 days
(18 Reviews)
3.5
konanhenry1111

"""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"""

$250 USD in 2 days
(5 Reviews)
1.8
sharifemran420

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.

$50 USD in 2 days
(2 Reviews)
1.4