Find Jobs
Hire Freelancers

Do some Excel Work - Datascrapping Excel & VBA coding

€30-250 EUR

Cancelado
Publicado hace casi 7 años

€30-250 EUR

Pagado a la entrega
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.
ID del proyecto: 14294791

Información sobre el proyecto

27 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
27 freelancers están ofertando un promedio de €119 EUR por este trabajo
Avatar del usuario
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
€150 EUR en 2 días
4,9 (388 comentarios)
8,1
8,1
Avatar del usuario
I am an excel expert. Read the project specs. Looks like this project is feasible. Just want to understand and make sure some of the requirements ..so kindly open PM to discuss work and budget..I am based in california and can talk over phone to understand the requirements and will provide support though out the project till you are satisfied with the work.. Regards,
€200 EUR en 5 días
5,0 (431 comentarios)
7,5
7,5
Avatar del usuario
Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets filled with formulas and VBA code. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. I am online from 3pm to 11pm Mon-Fri and 8am to 11pm Sat-Sun (GMT+3). If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
€80 EUR en 1 día
4,9 (256 comentarios)
7,6
7,6
Avatar del usuario
I am a guru in Excel, and I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. more on that, I develop financial modules including business valuation methodology & ratios (INPV, IRR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.)Therefore, I can help you design, build or modify spreadsheets in Excel to deliver professional analysis and strong functionality suited to your needs.
€150 EUR en 3 días
4,9 (92 comentarios)
7,2
7,2
Avatar del usuario
Greetings! Thanks for providing detailed requirements. I have read the requirements fully and understand the same. I have 18 years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last 12 MONTHS , I have spent at least 225 HOURS on automation in Excel every month. I can write the VBA code for your requirements. If awarded, I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Have a Great Weekend! Srinivasan Krishnamoorthi
€80 EUR en 1 día
5,0 (211 comentarios)
6,9
6,9
Avatar del usuario
I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Please contact me to discuss the details. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
€120 EUR en 2 días
4,8 (198 comentarios)
7,2
7,2
Avatar del usuario
Hello! My name is Irnes and I'm a data entry/web search specialist from Bosnia and Herzegovina. I'm here to prove my skills and quality of the work. The Freelancer website gave me a preferred status. More than 95% of my completed projects are done on time, 100% on budget. My bid is negotiable only when the amount of data is not precise. I have never changed my bid or asked the client for more money when the project is accepted. My best skills are: - any type of data entry, data collection - MS Office related jobs - PDF conversion to any format - web search / internet research / web scraping - posting the listings on the websites. - video and photo editing jobs. On the bigger projects, I work with the cooperates. My reviews on the Freelancer website are speaking enough about my ability to work. I'm not placing the bid if I'm not at least 80 % sure that I can do the job. I accept the project only when I'm 100% sure that I can complete it on budget and on time. Hope you'll recognize my interesting and contact me. Thank you for reading this. :) Best regards, Irnes.
€150 EUR en 3 días
5,0 (84 comentarios)
7,0
7,0
Avatar del usuario
Hi I have checked the document and spreadsheet. Understood. I can create a PHP script that will take the spreadsheet as input and will output the updated spreadsheet after doing all 4 tasks you have specified. You will be able to run the script locally on your PC. So please let me know if you are open to considering PHP script instead of VBA. Looking forward to seeing your reply. Thanks. Regards Ahsan
€150 EUR en 4 días
4,9 (90 comentarios)
6,7
6,7
Avatar del usuario
we have expertise in this domain(web scraping , Excel VBA , data processing , data entry). Client satisfaction is our main motto for long term relationship.
€100 EUR en 3 días
5,0 (48 comentarios)
6,4
6,4
Avatar del usuario
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Abhinav
€86 EUR en 1 día
4,9 (167 comentarios)
6,5
6,5
Avatar del usuario
Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
€133 EUR en 3 días
4,6 (102 comentarios)
6,2
6,2
Avatar del usuario
Sir, I reviewed your job description and am very interested to work with you. I can complete with fast and accurately. Please consider my bid. Thanks........Shariful
€166 EUR en 2 días
4,9 (54 comentarios)
5,5
5,5
Avatar del usuario
- Can get the text split and have the missing fields identified by a color coding. - Remove the spaces in front and trailing ones. - Have done similar Text splitting, identifying text for a Exam scoring system, whereby the scores are based on the number of keywords available within the essay. (Freelancer Project). - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Data extraction using API. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on recent projects. Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - Stocks Portfolio - Showing client portfolio stocks with various indicators, Momentum indicators based on portfolio. - University, US -
€70 EUR en 4 días
4,6 (51 comentarios)
6,1
6,1
Avatar del usuario
HI I am an excel-vba Expert and I can finish your project so fast start the chat to discuss more............................................................................
€77 EUR en 3 días
5,0 (37 comentarios)
5,3
5,3
Avatar del usuario
Dear Sir/Madam, thank you for the very detailed and illustrative guidance. I have 12 years of experience in data processing using Excel and VBA while working in audit and accounting. I have completed a number of projects on Freelancer involving use of Excel and VBA to automate data processing and analysis. These projects included, among other things, automatic comparison of contact lists, removal of duplicates and clean up of data lists for web upload or further analysis. I will be glad to help you with the project. Thank you!
€80 EUR en 2 días
5,0 (65 comentarios)
5,4
5,4
Avatar del usuario
Hi, I am working as financial analyst in a NASDAQ listed company. I also have experience of more than 5 of MS Excel specifically in pivot, charts, dashboards, advance formulas and VBA etc. Do let me know of further details. I can do your work in lowest possible time.
€145 EUR en 2 días
4,5 (37 comentarios)
5,3
5,3
Avatar del usuario
Hi, i am available i can do it, i am reading the description now, i am used to complete similar projects. Thanks
€155 EUR en 3 días
4,9 (23 comentarios)
4,6
4,6
Avatar del usuario
Hello, I read your instructions in the description as well as the Word file. I fully understand what you asked for and I can accomplish it by having the professional experience needed in the Excel, by working on similar projects over the last few years. I'll be glad to work with you! If you want please contact with me for more details! Thanks!
€120 EUR en 3 días
5,0 (3 comentarios)
3,9
3,9
Avatar del usuario
dear, Thank for your detail requirement. Could finish all of them in a short time !
€100 EUR en 2 días
4,6 (13 comentarios)
3,9
3,9
Avatar del usuario
Hi there, I'm an Excel expert having rich experiences of Excel VBA. I can help complete the job well with good quality. Look forward to hearing from you soon and working with you. Best Regards, VL
€60 EUR en 2 días
4,9 (11 comentarios)
3,7
3,7

Sobre este cliente

Bandera de FRANCE
PARIS, France
5,0
62
Forma de pago verificada
Miembro desde ene 17, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.