Completed

Do some Excel Work

Hello,

I’m looking for a freelancer that can do VBA code.

The objective is to :

TASK 1 – SPLIT A TEXT IN THE RIGHT A COLUMN

Solve the problem of the Description column

There are two columns “Description” one in the middle of the tab (AZ column) and one at the end (CA):

- The first one is always empty (so you don’t have to do nothing here)

- The second one combines the description comments (that are in the right column) and some other columns and their results (see below multiple examples)

We got some bug. Some info went to this “description” column.

So we really want you find info about this column and you fill them in ALL others rights columns (next step, budget, autorité…)

TASK 2 - Put a color on all missing fields

TASK 3 – Drop Spaces in front of first name, name and email address

It not always the case but sometimes there is a space as first letter.

BUT be careful, here is some example of what needs / doesn’t to be done. We really talk ONLY about first letter is a space

TASK 4 - Create a new column “Contexte” (meaning Origin) by separating

Currently, the context of our leads is in the title based on the model “ (context) – company ”. We want two separates columns, “Company” and “Contexte”.

The Dash “-“ is the separator.

Skills: Data Entry, Data Processing, Excel

See more: excel Do some Excel Work aviation, excel Do some Excel Work, excel ping email address, excel change email address website, freelance work excel vba, flash email form drop menu address, track work excel, macros written excel 2000 work excel 2007, contract work excel access, excel 2000 macros work excel 2007, article submission work excel, show project work excel, work excel file, contract work excel, online contract work excel, excel automate email files directory, data entry work excel, work excel database, data excel populate email, surf internet work excel

About the Employer:
( 46 reviews ) PARIS, France

Project ID: #14620820

Awarded to:

ketas

Dear, As dicussed , I could help you on this request. You will happy with my work ! Relevant Skills and Experience VBA/ MS Excel Proposed Milestones $20 USD - Initial $80 USD - Finish

$100 USD in 2 days
(12 Reviews)
3.8

25 freelancers are bidding on average $94 for this job

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this this Task as per your requirement. Relevant Skills and Experience I have the 5 years More

$180 USD in 3 days
(231 Reviews)
7.4
SBITServices

Hello , I have read your project description and understood your requirement. The tasks you mentioned are easy. I have 5 years experience and Check our reviews to confirm our work quality(100%completion rate) Relev More

$30 USD in 3 days
(322 Reviews)
7.2
sandroshubladze

Hello, I am Excel Expert and VBA Developer I can create for you desirable macros If interested, contact me Tanks & Regards Relevant Skills and Experience Excel VBA Proposed Milestones $83 USD - P

$83 USD in 2 days
(169 Reviews)
7.1
paris2785

I've read your brief and can see that you'd like to have an Excel spreadsheet. Relevant Skills and Experience I have 7 years experience designing and developing Excel spreadsheets filled with formulas and VBA code. More

$80 USD in 1 day
(122 Reviews)
6.5
ksriniravi

Thanks for providing detailed requirements. I have read the requirements fully and understand the same. I can develop a macro to meet the stated requirements for USD 60. Relevant Skills and Experience 18 years expe More

$60 USD in 2 days
(136 Reviews)
6.5
chriskerpini

Fix the 'Description' column, purge the leading-trailing spaces from names and email addresses, color the cells for all missing fields, create two separates columns “Company” and “Contexte” Relevant Skills and Experie More

$90 USD in 2 days
(66 Reviews)
6.6
nagybatonyi

In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Relevant Skills and Experience I have a university degree in econo More

$45 USD in 0 days
(62 Reviews)
5.7
nineoneone

Read the description, understood it completely. I have done similar project, as you can read from my reviews. I take pride in the work, and am most interested in impressing you with quality work. Here are the reasons w More

$30 USD in 3 days
(21 Reviews)
4.7
sourabhg98

The bid includes completion of the project [login to view URL] the 4 tasks as mentioned. Relevant Skills and Experience I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] with over 4 More

$88 USD in 1 day
(41 Reviews)
4.6
ESOLUTIONSSS

A proposal has not yet been provided

$50 USD in 1 day
(32 Reviews)
4.6
furqanahmed55

Hello, I graduated from Boston University USA. I have a lot of experience doing data entry. I never miss work and always deliver on time. My personal qualities are: - Detail Oriented, as handled many sensiti More

$100 USD in 1 day
(5 Reviews)
4.4
cyash61

The bid has been made assuming approx 10 hours of time needed to finish the work. Relevant Skills and Experience Excel experience : 7 years Data analysis experience : 7 years Proposed Milestones $50 USD - After the k More

$200 USD in 3 days
(4 Reviews)
3.9
avidusman

With 9 plus years of experience, I am confident that I can fulfill requirements of project very efficiently in a very reasonable time. I am looking forward to discuss with you about this project. Relevant Skills and E More

$49 USD in 1 day
(6 Reviews)
3.5
hunmin888

Hi, sir! I have a close look to your project. I have a good skill in vba programming. If you award this project to me, we'll complete it in time. Our budget may be negotiable Thanks Relevant Skills and Experience Hi More

$133 USD in 3 days
(7 Reviews)
3.7
tanmoyspi

Hello, Thank you very much for this Data Entry Project. I read through the job details extremely carefully and understand your required, for this I am absolutely sure that I can do the project very well. I can complet More

$30 USD in 3 days
(16 Reviews)
3.1
ENRICOJ

HI.I WOULD LIKE TO ASSIST YOU AS I HAVE EXTENSIVE KNOWLEDGE OF DATABASE PRODUCTS SUCH AS MS ACCESS,MS EXCEL,VBA AND DATABASE DESIGN .PLEASE CONTACT ME FOR FURTHER [login to view URL] [login to view URL] Relevant Skills and Exp More

$60 USD in 3 days
(3 Reviews)
3.1
$50 USD in 3 days
(3 Reviews)
3.1
rumesh402

Hello, my name is Rumesh. I noticed your advertisement about the project and think I would make an excellent candidate for it. I read through the job details extremely careful and I'm absolutely confident that I can d More

$50 USD in 0 days
(9 Reviews)
2.6
iftekhertalukder

Hello, I am able to do the work on your project ensuring accuracy with responsibility and the quality of my work is the reflection of my sincerity. Thanks Relevant Skills and Experience Excel work, Data analysis, Data More

$80 USD in 2 days
(3 Reviews)
2.0
$50 USD in 1 day
(2 Reviews)
1.2