Two Simple Excel Macros - VBA Needed

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la 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

Procesamiento de datos Excel PHP Visual Basic Visual Basic para aplicaciones

Nº del proyecto: #18657936

Sobre el proyecto

12 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

bouslimi1979

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

$200 USD en 3 días
(280 comentarios)
7.6

12 freelancers están ofertando un promedio de $206 por este trabajo

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 Más

$100 USD en 3 días
(426 comentarios)
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 Más

$300 USD en 2 días
(195 comentarios)
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 en 10 días
(111 comentarios)
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 Más

$250 USD en 5 días
(60 comentarios)
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 Más

$150 USD en 3 días
(65 comentarios)
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 Más

$300 USD en 10 días
(7 comentarios)
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 Más

$250 USD en 4 días
(20 comentarios)
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 Más

$150 USD en 5 días
(43 comentarios)
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 Más

$70 USD en 3 días
(18 comentarios)
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 en 2 días
(5 comentarios)
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 en 2 días
(2 comentarios)
1.4