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...
I'm a specialist in Excel and macros. I can do it without any trouble. Relevant Skills and Experience Lots of works
Bu iş için 29 freelancer ortalamada $132 teklif veriyor
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.
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]
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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
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!
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. Daha Fazla
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
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.