Find Jobs
Hire Freelancers

VBA Programmer Required to improve an existing Macro

£10-20 GBP

Completed
Posted over 5 years ago

£10-20 GBP

Paid on delivery
Looking for a VBA expert to amend an existing Macro which will loop through files in a folder, copy a certain sheet in all the files and paste to existing sheets. We have a macro that requires improvements so we can automate part of our processes. The current macro is copying the required sheet from files in a given folder and it is pasting the results to one sheet. We need it the macro to paste existing sheets based on the file names and we also like to make the pathway to be dynamic as well. The full requirements are in the attached file.
Project ID: 17648384

About the project

10 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

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
Awarded to:
User Avatar
Hi, Being experienced in working on excel vba macros extensively, I can help in getting macro modified as per your requirements mentioned in the word document. I assure you of quick and efficient solution and available with bandwidth to start on work now itself. Waiting for your response for further discussion on chat. Thanks.
£20 GBP in 1 day
4.8 (99 reviews)
5.8
5.8
10 freelancers are bidding on average £35 GBP for this job
User Avatar
I know how to copy data by looping through files in a folder. The data can be pasted into corresponding sheets depending on the name of the file I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
£30 GBP in 1 day
4.9 (80 reviews)
5.8
5.8
User Avatar
Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. Passionate about excel automation.
£30 GBP in 1 day
4.9 (31 reviews)
4.9
4.9
User Avatar
Hello, Sir, This project can be done by today Kindly send me a msg and I will start to modify the coding according to your attachment I look forward to hearing from you Thanks regards Thushara
£28 GBP in 0 day
5.0 (25 reviews)
4.3
4.3
User Avatar
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
£13 GBP in 1 day
4.4 (19 reviews)
3.8
3.8
User Avatar
Hello, I have read your requirements and it is possible to make the dynamic link and create different sheets base on file name. I can do it for you at reasonable price. I have years of experience working with Excel VBA both at my work and in Freelancer. Please pm me for further discussion. Thank you!
£18 GBP in 1 day
5.0 (8 reviews)
2.6
2.6
User Avatar
Hi there, i understand your requirement and can do the work perfectly using my outstanding experience. Please award me the project so that we discuss it more Thank you.
£20 GBP in 1 day
4.8 (9 reviews)
2.4
2.4
User Avatar
Hi Sir I'm a new freelancer looking for positive feedback which is why I'm willing to do this project at minimal cost or even for free. Please let me know your requirements. Regards
£10 GBP in 1 day
5.0 (5 reviews)
1.7
1.7

About the client

Flag of UNITED KINGDOM
Ipswich, United Kingdom
5.0
2
Payment method verified
Member since Jun 17, 2017

Client Verification

Other jobs from this client

Hire a Logo Designer
£20-250 GBP
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.