Find Jobs
Hire Freelancers

Create four MS Excel macros to process/clean spreadsheet data

$250-750 USD

Fullført
Lagt ut omtrent 5 år siden

$250-750 USD

Betalt ved levering
The goal of this project is to write four Excel macros to process data in Excel. The macros will perform a variety of functions to manipulate the data in an Excel workbook including: -Deleting rows based on pre-defined (hard-coded) criteria in a particular cell, including if a cell is blank (but the row is otherwise populated) -Deleting columns -Adding columns and populating the column with values based on a formula or defined criteria -Creating new worksheets and moving specified columns to those worksheets -Deleting rows based on the presence of duplicate values in the same column -Display a message based on the value of a cell or variable -Accept input from a user Raw (unprocessed) data and an example of the successful output will be provided to assist with this task. I will be available to answer questions if they arise during the development process. Macros must be able to handle sheets with significant amounts of data, including those with up to 500,000 rows. Macros must be able to operate on the Mac OS version of Microsoft Excel (I believe macros are cross-platform compatible but want to include this to be sure - work will be validated on MS Excel 2016 for Mac). Please review the attached requirements for the macros before placing a bid so the level of difficulty of this project is clear. Three different Excel workbooks will be provided as part of this project. Two of the workbooks will each require one macro and the third will require two macros. Interested bidders should be have experience with coding Excel macros in Visual Basic for Applications.
Prosjekt-ID: 18557676

Om prosjektet

12 forslag
Eksternt prosjekt
Aktiv 5 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$350 USD om 5 dager
4,9 (360 omtaler)
8,0
8,0
12 freelancers are bidding on average $413 USD for this job
Brukeravatar
Hello? How are you? I have good experiences in "Create four MS Excel macros to process/clean spreadsheet data" as you can see my profile for these (Data Processing, Excel, Microsoft Office, Visual Basic, Visual Basic for Apps). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.
$555 USD om 3 dager
4,8 (99 omtaler)
5,9
5,9
Brukeravatar
Hi there? I read your project description just now and I am very interested in your project. As you can see on my profile, I am a senior full stack programmer with great skills and rich experiences in these fields. Especially, I am familiar with VB and MS Macro too. I am sure I can do this project perfectly. Please contact me to discuss more details. Regards
$555 USD om 10 dager
5,0 (3 omtaler)
5,0
5,0
Brukeravatar
Software Engr here ready to serve you sir I will do your Macro task well in time best and easy to prove data Time efficient
$250 USD om 3 dager
4,9 (11 omtaler)
4,1
4,1
Brukeravatar
Dear sir. Your project attracted my attention at first glance, because I've extensive experience in Excel VBA Programming. I'm really confident about your project, and very eager to join your project. If we have a chance to cooperate, I'll do my best to provide wonderful result. Looking forward to your response. Best Regards.
$400 USD om 10 dager
4,8 (5 omtaler)
3,8
3,8
Brukeravatar
Hi Sir, I see you need VBA Programming in Excel to utilize your data efficiently. I have seen your attachment and read the requirements and also your description. I can design this VBA programming for you. It doesn't seem hard to me but just time taking as to verify all the pros and cons and handling errors. I believe that Excel on the Mac works exactly the same as in Windows (Never tested because never get machine). But in case if there is some error tested on Mac, I'll sort it out. Based on the attachment, i may need your datasheet too. That'll be efficient and fast to process and deliver you the task. But i can do it on my own with the dummy data. I have built large scale Excel management systems for the companies to manage all of their data (Monthly 10,000 Rows increment). Excel managed data, made reports, delivered that to concerned department through email. You can ask the sample files of my previous work, and also can review my profile containing reviews for the excel vba and Google sheets scripting tasks. I believe this task can be completed within 7days. But i'll keep it to 10, for the testing and debugging if needed based on Mac. Let's discuss it in chat. I'm available and can start work on it right away.
$678 USD om 10 dager
5,0 (4 omtaler)
3,5
3,5
Brukeravatar
Hello. My name is Luis and I'm a current HP employee backend developer and analyst. Your request is basically an ETL (Extraction, Transform and Load). I have over 15 years of experience developing in VBA business solutions and over 8 years in ETL. High communication skills and no language barriers. Your request can be accomplish within budget and time frame. With the highest performances possible. Looking fowar to hear back from you. Regards.
$400 USD om 5 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
I am looking for the client who has regular requirement of freelancers to complete his job. I have a sound knowledge of MS Excel which includes VBA, Power Query etc.
$388 USD om 10 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hello Respected Client Hope you will be doing fine. I have read your job description and I find myself suitable for this job. I have a very strong hold on data entry. Thanks Regards Muhammad Intizar
$500 USD om 5 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
I have been working extensively on Excel as well as VBA over the last 4 + years and have created multiple automated Dashboards, reports, templates, Scrapers etc. for clients across different verticals. I am known for my error free client deliverables. I have gone through your requirements in the description and am confident that i can deliver your project in a timely manner I look forward to connecting with you to understand the finer details of the jobs you had in mind and to have a look at the data and the output file required. If you are interested, you can have a look at my portfolio for examples of a couple of automated dashboards that i have built on Excel
$275 USD om 3 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

UNITED STATESs flagg
Washington, United States
5,0
3
Betalingsmetode bekreftet
Medlem siden sep. 16, 2018

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.