MS Excel - VBA Expert Required to Build Macros in several spreadsheet

$8-15 AUD / hour

Closed

Posted

over 6 years ago

$8-15 AUD / hour

Hi. I'm looking for someone who can update about 4 or 5 of my work spreadsheets. These spreadsheets match work claims to received payments via vlookups, sumifs and index matches, and allows me to pass on payment to the worker. I'd like to review how this is done and then automate steps of the process. Basically, 1 spreadsheet is received to list payments, this is matched against the claims etc. It is pretty standard as it is and I need to enhance it and provide a fool-proof solution. There are several separate spreadsheets that require this to be done to them. VBA will be basically buttons that run macros but will need some script to go to a website, login and then get data files and also copy and paste information from the screen etc. Would prefer a VBA expert with financial background as an understanding of payments etc would be an advantage. I will pay either by hour based on agreed timeframe or you could provide individual quotes for each worksheet. Being able to read, understand and speak English clearly is very important. In your reply, please let me know your skillset and why you would be great for this project. There will be other opportunities for more work in the near future so I would like to hire someone who is available long term for other projects too. Please send me any questions you would like answered. I have an idea on price but happy to negotiate what you believe you are worth. Thank you for your time. Kerryn

Project ID: 15531836

About the project

29 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

29 freelancers are bidding on average $12 AUD/hour for this job

@seaanddream

Hi, my name is Sevinc. I am excel/vba expert with finance background... I read your "MS Excel - VBA Expert Required to Build Macros in several spreadsheet" project descriptions carefully before bidding. I checked your requirements as well... I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.

$15 AUD in 40 days

5.0

(334 reviews)

8.1

@paris2785

Hi. My name's Paris. I've been developing Access databases for almost a decade. You are welcome to check my portfolio for past works of mine accompanied by my clients' reviews. I am capable of supporting your task in enhancing all your spreadsheets and I'd rather work on an hourly basis once we agree to proceed. I am usually online from 3 to 11 pm (GMT+2).

$15 AUD in 40 days

4.9

(268 reviews)

7.6

@dvcontact

Hi, Reading your project description about building macros that will go to a website, login and then get data files, makes me feel like you have me in mind when creating the project. I have all it takes to deliver - 100%. Rather than just show you past VBA projects, I can exceed your expectation by completing 10% of your job based on your requirement without any commitment. Let my reviews do the talking. I would be grateful to know what is required to secure this bid. Thanks for your consideration Smith

$10 AUD in 40 days

4.9

(61 reviews)

6.5

@danielgpratidya

Hi, I am an excel expert and I can do anything with vba excel macro. It'd be better if we discuss every spreadsheet you have one step at the time, so I can give you more accurate solution. For now, can you give me 1 website url login page, so I can give you sample where you can place your username and password? If you want me to get the information you need in a specific page, please tell me what they are and please create for me username and password for testing purpose only. My rate is $20 per hour as I bid. I have more than 15 years experience working on excel spreadsheet and its automation. Have 100% completed project rating, 100% on time and 100% on budget Feel free to review my profile page. Best Wishes, Daniel

$20 AUD in 40 days

5.0

(203 reviews)

6.6

@caabdul

Hi there, I am Abdul and have the skills exactly as you want. 8 years of experience in excel and an excel pro. I can deliver the job with perfection but need to see each task to decide the rate, not hour based. Thanks

$15 AUD in 15 days

4.8

(81 reviews)

6.5

@abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application -- Expert in ASP.NET,MVC I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov

$12 AUD in 40 days

4.9

(62 reviews)

5.5

@desconit

Hi Kerryn, I have 12 years of development experience in VBA, VB6.0 and VB.net. I have done several VBA tasks for Excel and have financial background as well. In VBA we can use HTMLDocument and InternetExplorer objects can be used to log in the desired website. As far as capturing desired information from the screen, i need to check this part. Can you please provide the link of website where you want to log in and get information? I look forward to hearing from you. Regards, Farooq

$13 AUD in 40 days

5.0

(11 reviews)

5.1

@whitehorsetechn

Greeting, I have understood your Build Macros in several spreadsheet task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Entry, Data Processing, Excel, Finance, Visual Basic

$10 AUD in 40 days

4.8

(14 reviews)

5.2

@prabakarm23

Greetings for the Day!!! I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details

$16 AUD in 20 days

5.0

(56 reviews)

4.8

@chintuag

Dear Hiring Manager, I have read the project description and would like to offer my expertise in your project. I am a professional with extensive experience in excel. I have worked on projects using VBA/Macros and Complex Formulas using existing data and downloading data from the websites. (Automation of Data scraping from websites which includes login and password) I am available to work on your project fulltime and assure you that you would be happy with my services. Looking forward to hear from you Regards Chintu

$12 AUD in 30 days

5.0

(11 reviews)

4.0

@arslanu2

I am available to work with you on your VBA project. I have a financial background also. Would you like to outsource it to my skills?

$15 AUD in 40 days

5.0

(3 reviews)

3.8

@thuyduongrands

Dear Mardam or Sir, You need an accountant . I am the one you need . I have great experience working as an Accounting throughout my career. I have over 10 years of experience and knowledge of accounting and good skill data entry, good at Office software and Xero, Myob, Quickbooks software all so. I will benefit you and your company if hired by you. I can deliver projects on time and to a high standard. I am ready to be hired by you now. Work plan: I will use 1 to 8 hours/day work for you with the most careful and correct accounting standards. Please hire me and contact me.

$13 AUD in 40 days

4.6

(7 reviews)

3.7

@rcnvw

I have a strong financial background and have worked on projects relating to Payroll / Invoicing. I have been away from freelancing for a while and now have resumed to take on projects. I am good at functional aspects as well as on technical design and implementation and look forward to working with you.

$16 AUD in 40 days

4.8

(6 reviews)

3.5

@pencitku

A proposal has not yet been provided

$11 AUD in 25 days

5.0

(4 reviews)

2.1

@jlmeseguer

I'm good. You wrote a review of Me based on our prior transaction and you were very complimentary. I want to thank you for that.

$10 AUD in 10 days

4.9

(3 reviews)

1.7

@sahumk2000

Hi Greetings of the Day, I am interested in this task, I am full time freelancer carrying 13 yrs of experience in Mobile development, Web and Windows development using ASP.Net, MVC, C#, WPF, SQL server, Xamarin, WebAPI, XML, JQuery, Bootstrap, Cr Reports, VB6, ClassicASP, COM/DCOM etc Please feel free to contact me. skype: sahu_mk Thanks

$12 AUD in 40 days

5.0

(1 review)

1.8

@arshadsa

I have done similar project earlier. I am confident that I will be able to complete the job in very short time

$8 AUD in 40 days

5.0

(1 review)

1.4

@tariqul71

I am very interested in Data Entry task and also i have a good experience in this field. I want to spend my time, 40hrs per week. Thanks

$8 AUD in 40 days

0.0

(0 reviews)

0.0

@nishainsan22

Greetings!! I have expertise in VBA even i can customise its overall framework by programming. Please give me a chance you will love to do work with me.

$12 AUD in 40 days