Completed

VBA excel macro - Move data from Notes column in .csv or .xls to other columns for data accuracy

Need a 20,000 line .xls or .csv sheet to be cleaned up that has been exported from a database.

The cleanup with involve delivering the project back with the vba (for future functionality we need) included that macro will perform the following:

a)sign NDA through freelancer (data is sensitive)

b) take data from one column (the Notes/Description column) that has massive notes in it and

1. take any names of people and title and email and phone of that person and create a new line in the .xls/.csv sheet and auto fill in the organization name and address, etc already populated

2. do this for multiple names, if there are more than one person named

3. make sure to keep the data in the original source column too

4. make sure that emails go in emails column and title, and phone - to match the person that is noted in the column or to pick the main 1st person mentioned and any email/phone/title to go with that person

5. change the column that is the qualification to Warm Lead vs. none or Cold if there is an update to that .xls / .csv line or row

6. change the column on that line/row for campaign to "EMMA v1 Cleaned Leads", if any data is in the notes that is being transferred to the other data columns mentioned (vs old campaign name)

deliver back with vba excel macro to us with above completed and ready to run in-house and sort, etc...

thank you!

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

See more: excel macro move data existing cell, vba excel macro excel 2003 free macro example, excel macro move cell contents, vba excel search value row column, vba excel macro cut paste cells, excel macro loop paste column, vba excel macro shell, excel macro move rows need speed process, excel macro move word, status message paste complete vba excel macro, vba excel macro column unique values, excel macro move next row, check availability addin references vba excel macro, excel macro copying cell column, excel macro find select column paste, vba excel macro comments examples, vba excel macro connect mathematica, vba excel macro cut paste column, vba excel macro screen capture, vba excel macro split string cells

About the Employer:
( 1 review ) Cedar Rapids, United States

Project ID: #23942058

Awarded to:

VbaStudio

I'm a specialist in Excel and macros. I can do it without any trouble. Relevant Skills and Experience Lots of works

$50 USD in 3 days
(1 Review)
2.8

29 freelancers are bidding on average $132 for this job

P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 USD in 2 days
(354 Reviews)
7.4
dvcontact

Hi, Would you like to see a quick demo of your Exported data from a Database cleaned up before you award the project? You can consider it professionally done in less than 24 hrs. Rather than fill this proposal with a More

$150 USD in 5 days
(57 Reviews)
6.5
TechNamrata09

Hello Sir, If you HIRE me today, I have special rates for you on this project. Hourly Rates: 3 USD per hour Availability: 40+ Hours per week. Please check my Vlookup skills of Ms-Excel. [login to view URL] More

$200 USD in 7 days
(36 Reviews)
6.4
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$250 USD in 2 days
(144 Reviews)
6.2
finecodervw

Hi, I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in Excel macro More

$125 USD in 4 days
(96 Reviews)
5.9
vlayausa

Hello, I am proficient with Excel and VBA. I would love to help with this project. Please contact me for more information.

$89 USD in 3 days
(145 Reviews)
5.9
zu02

Hi I'd like to be considered as a programmer for your ms access project. I'm professional experienced ms access programmer. please see my portfolio here. I'll make all your forms, reports etc just on your need via very More

$250 USD in 7 days
(33 Reviews)
5.8
bhupendrayadav

I am full time freelancer with postgraduate having more than 6 years of experience in advanced excel based tools, VBA automation, dynamic dashboards, web application, web dashboards, google spreadsheets, google scrip More

$100 USD in 1 day
(40 Reviews)
5.6
vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets More

$140 USD in 3 days
(101 Reviews)
5.7
indrapandu

Hi, I'm VBA expert. I have seen your requirment for transmorning Notes column into proper row. I have done many excel automations in large scale, including something that similar to this. Please review my profile, I ne More

$75 USD in 1 day
(37 Reviews)
4.9
Ahmed818

Hello, ⭐⭐⭐⭐⭐ i am expert in this kind of jobs samples of my excel VBA jobs ⭐⭐⭐⭐⭐ https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-r More

$30 USD in 1 day
(68 Reviews)
4.7
ielucerotrad1

I can do the job and I can start right away. Would need to see an example of a typical Notes/Description column notes to better understand the procesing required (identify names, identify organization etc.). About me: More

$250 USD in 4 days
(21 Reviews)
4.2
reubengi

Hi there, I have good experience working with Excel and creating VBA macros to do the type of task you have described. I will deliver on time and quality. Can you post a sample of the file? Regards Reuben

$100 USD in 3 days
(8 Reviews)
3.8
jaelahoe

Hi there! Since it's urgent, do send me the file and give me 3 hours to work on it. Will show you a preview before you award. Cheers!

$115 USD in 1 day
(6 Reviews)
3.4
nemanjadj20

Hello? I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. Thank you for your time. I have attached samples of work very similar to what you are seeking. More

$155 USD in 1 day
(3 Reviews)
3.5
pkaslam

I can do it perfectly please masses me , for more discussion I Read your description and I am ready to do your work. I have excellent experience in digital marketing, Data Entry, lead generation and also seo. I can s More

$30 USD in 7 days
(11 Reviews)
3.1
mauricioalberin

Hello, I would like to help you with your project, I have a lot of experience in Excel and VBA macros. I have a Master in Applied Computing. I have more than 10 years of experience in programming in several languages More

$80 USD in 4 days
(7 Reviews)
2.8
ARTICLEYOUWANT

Hello, I provide high-quality Virtual Assistant services from data entry and data mining to web research and copy-paste tasks. These assignments may be simple, but you need someone who intuitively understands what you More

$170 USD in 7 days
(2 Reviews)
2.9
mahmoudkaseemeg

Hello. My name is Mahmoud and my professional is VBA and it's my main field as I graduated with the same specialist since 2005 and if you require some example just tell me to send example to you Regards

$140 USD in 7 days
(2 Reviews)
2.2
zharivera0210

I am an experienced bookkeeper and proficient using Excel. I can handle this project with accuracy if given an opportunity. Relevant Skills and Experience Expert in MS Excel, word and must give attention in details.

$111 USD in 5 days
(0 Reviews)
0.0