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!

Taidot: Excel, Visual Basic, Visual Basic for Apps, tietojenkäsittely, tiedonsyöttö

Näytä lisää: 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

Tietoa työnantajasta:
( 1 arvostelu ) Cedar Rapids, United States

Projektin tunnus: #23942058

Myönnetty käyttäjälle:


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

$50 USD 3 päivässä
(1 arvostelu)

29 freelanceria on tarjonnut keskimäärin 132$ tähän työhön


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 2 päivässä
(354 arvostelua)

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 Lisää

$150 USD 5 päivässä
(57 arvostelua)

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] Lisää

$200 USD 7 päivässä
(36 arvostelua)

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 2 päivässä
(144 arvostelua)

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 Lisää

$125 USD 4 päivässä
(96 arvostelua)

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

$89 USD 3 päivässä
(145 arvostelua)

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 Lisää

$250 USD 7 päivässä
(33 arvostelua)

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 Lisää

$100 USD 1 päivässä
(40 arvostelua)

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 Lisää

$140 USD 3 päivässä
(101 arvostelua)

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 Lisää

$75 USD 1 päivässä
(37 arvostelua)

Hello, ⭐⭐⭐⭐⭐ i am expert in this kind of jobs samples of my excel VBA jobs ⭐⭐⭐⭐⭐ Lisää

$30 USD 1 päivässä
(68 arvostelua)

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: Lisää

$250 USD 4 päivässä
(21 arvostelua)

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 3 päivässä
(8 arvostelua)

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 1 päivässä
(6 arvostelua)

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. Lisää

$155 USD 1 päivässä
(3 arvostelua)

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 Lisää

$30 USD 7 päivässä
(11 arvostelua)

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 Lisää

$80 USD 4 päivässä
(7 arvostelua)

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 Lisää

$170 USD 7 päivässä
(2 arvostelua)

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 7 päivässä
(2 arvostelua)

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 5 päivässä
(0 arvostelua)