Two Simple Excel Macros - VBA Needed

Concluído Postado há 5 anos Pago na entrega
Concluído 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

Processamento de dados Excel PHP Visual Basic Visual Basic para Apps

ID do Projeto: #18657936

Sobre o projeto

12 propostas Projeto remoto Ativo em há 5 anos

Concedido a:

bouslimi1979

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

$200 USD em 3 dias
(280 Comentários)
7.6

12 freelancers estão ofertando em média $206 nesse trabalho

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 Mais

$100 USD in 3 dias
(426 Comentários)
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 Mais

$300 USD in 2 dias
(195 Comentários)
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 dias
(111 Comentários)
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 Mais

$250 USD in 5 dias
(60 Comentários)
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 Mais

$150 USD in 3 dias
(65 Comentários)
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 Mais

$300 USD in 10 dias
(7 Comentários)
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 Mais

$250 USD in 4 dias
(20 Comentários)
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 Mais

$150 USD in 5 dias
(43 Comentários)
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 Mais

$70 USD in 3 dias
(18 Comentários)
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 dias
(5 Comentários)
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 dias
(2 Comentários)
1.4