Create four MS Excel macros to process/clean spreadsheet data

$250-750 USD

Imekamilika

Imechapishwa

about 5 years ago

$250-750 USD

Kulipwa wakati wa kufikishwa

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.

Visual Basic for Apps

Kitambulisho cha mradi: 18557676

Kuhusu mradi

12 mapendekezo

Mradi wa mbali

Inatumika 5 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@schoudhary1553

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 ndani ya siku 5

4.9

(360 hakiki)

8.0

12 wafanyakazi huru wana zabuni kwa wastani $413 USD kwa kazi hii

@lightingdavid

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 ndani ya siku 3

4.8

(99 hakiki)

5.9

@DevStar925

Bedera ya LAO PEOPLE'S DEMOCRATIC REPUBLIC

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 ndani ya siku 10

5.0

(3 hakiki)

5.0

@chraheelbhatti

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 ndani ya siku 3

4.9

(11 hakiki)

4.1

@dinhfreedom

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 ndani ya siku 10

4.8

(5 hakiki)

3.8

@Apisylux

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 ndani ya siku 10

5.0

(4 hakiki)

3.5

@luisrmercadogar

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 ndani ya siku 5

0.0

(0 hakiki)

0.0

@vineetsingh23

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 ndani ya siku 10

0.0

(0 hakiki)

0.0

@muhammadintizar

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 ndani ya siku 5

0.0

(0 hakiki)

0.0

@akshaypunjabi

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 ndani ya siku 3