Find Jobs
Hire Freelancers

Programmer Needed for Excel VBA Project

$30-250 USD

Completed
Posted over 3 years ago

$30-250 USD

Paid on delivery
- Previous experience with QuickBooks Reports is a plus. - INPUTS: I have two (2) reports that I export FROM QuickBooks TO Excel: One (1) contains Inventory Qty per SKU per Location, and the other Excel report contains Backorder Qty per SKU per Location (for customer's orders). - OUTPUT: I want a list of SKUs with Qty>0 that are on both input reports. This will tell me which items/SKUs we have in stock but my Warehouse Pickers are not picking them.
Project ID: 28983418

About the project

31 proposals
Remote project
Active 3 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
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me.
$110 USD in 2 days
4.9 (213 reviews)
6.8
6.8
31 freelancers are bidding on average $97 USD for this job
User Avatar
Dear Employer, I understand how you want to link inventory and back order quantity using macro. I am an expert and will do your job. Please message me to discuss more. Thanks, Ashish
$123 USD in 2 days
5.0 (280 reviews)
8.3
8.3
User Avatar
Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast
$180 USD in 3 days
4.9 (499 reviews)
8.3
8.3
User Avatar
✅ Expert on Advanced Excel ✅ Hi there! I can generate a list of SKUs with Qty>0 that are on both input reports. I’m expert on VBA, Macro, Nested Formula & Function, Combine Multiple Sheet, Data Cleaning, Lookup, Vlookup, Hlookup, Nested IF, Array and Advanced Excel Automation related various administration tasks. Knock me over chat? So, we can discuss more about this project and start work. I hope to hear from you soon! Kindest regards, Aquib Javed
$50 USD in 1 day
5.0 (92 reviews)
6.5
6.5
User Avatar
Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 day
$60 USD in 1 day
4.9 (220 reviews)
6.6
6.6
User Avatar
Hey there, This can be done via formulas or using VBA programming. I’m an expert in excel VBA macros. Ping me to discuss more details. Thanks A
$45 USD in 1 day
4.9 (175 reviews)
6.6
6.6
User Avatar
Hi Sir, I understood the requirement completely. Need to identify which items/SKUs are in stock but still present in back log . I can complete this job quickly within 30minutes. Please ping back. Thank You Regards Rishi
$30 USD in 1 day
4.9 (161 reviews)
6.0
6.0
User Avatar
I am full time freelancer, providing automation consultancy to SME/MSME companies. I can develop an Excel based automation tools to automate business processes including calculation of large data and pivot tables. Below is a brief introduction of myself. I am postgraduate (MBA) with more than 7 years of experience in advance excel based templates and tools, MIS reporting, business automation, dynamic dashboards, VBA, Excel macros, financial modeling and data processing. Please go through my portfolio to have a better understanding of my expertise from my completed projects. My portfolio URL:- https://www.freelancer.com/u/bhupendrayadav. I have developed advance excel based automation tool for E&Y and Decathlon also. You can get your work done with highest quality and after development support at lowest price. No need for any upfront payment you can pay after final delivery. Looking forward to work with you.
$70 USD in 1 day
4.9 (50 reviews)
5.9
5.9
User Avatar
Hi there, You need to have an Excel-bound VBA to verify if back orders has stocks by consolidating the SKU's with QTY>0 from Inventory Qty per SKU per Location and Backorder Qty per SKU per Location reports? Please message me if this is any of what you need. I'll be standing by to help. -Ige
$70 USD in 2 days
5.0 (43 reviews)
5.4
5.4
User Avatar
Hi, I have more experiences in Visual Basic, MS EXCEL and VBA. I can write code to get OUTPUT as described from your Excel files. Feel free to discuss. Thanks
$50 USD in 1 day
5.0 (60 reviews)
5.6
5.6
User Avatar
Hi there, I can help you to get the desired result. I am a Microsoft Certified Professional in Excel and VBA as an Expert. Awaiting for your response. Regards, Karthick G.
$70 USD in 1 day
5.0 (42 reviews)
5.2
5.2
User Avatar
Hey! I will prepare a detailed report on inventory to trace the quantity on one click. I am a qualified chartered accountant and working in a Consultancy firm from 7 years. I had done ACCA, ICAEW, ICAP.I have experienced more than 40 companies on behalf of my firm. I was also working for Pepsi-Cola International at snacks plant. It is an honour for me to assist you in this task. Hoping for a positive response from you. *Fee will be negotiable according to your expected budget. I am looking forward to know more about this project. Thanks Regards Muhammad Zaman
$30 USD in 1 day
5.0 (16 reviews)
4.5
4.5
User Avatar
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this due to my experience with VBA script. It will be quick and accurate. I will start immediately and complete it within a few hours. If interested, we can discuss this further on chat.
$80 USD in 1 day
4.5 (23 reviews)
4.8
4.8
User Avatar
Hi , I am an MBA professional have 4yrs of experience in Analytics, Tableau, Advanced Excel, vba and Python. Being an analyst, I use excel and vba day in and day out. I don't have any experience on QuickBooks but if the output from QuickBooks is in csv or excel format, then this task can be easily done by me. Looking forward to work with you. Cheers.
$40 USD in 1 day
5.0 (9 reviews)
3.6
3.6
User Avatar
I'm not sure that you will need VBA for this project unless there is some other functionality that you need. it sounds like you can achieve with good old fashioned formulas (vlookup probably) This will be simpler to maintain and cheaper for you. Please message me and we can talk about this and i can let you know for sure. Cheers Neil
$40 USD in 7 days
5.0 (4 reviews)
3.2
3.2
User Avatar
Hi! Whilst reading your job description, I have a feeling that the excel VBA-based solution may be potentially slow/inefficient. I am proposing a basic software application (executable) that takes those 2 QuickBooks exports and generates the single spreadsheet based output. Veronika
$50 USD in 1 day
5.0 (1 review)
2.7
2.7
User Avatar
HI hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects. I has done tons of projects using VBA. I can give my full effort to deliver the project in on time with 100% quality and accuracy...I'm waiting for your kind response.
$140 USD in 5 days
5.0 (7 reviews)
2.8
2.8
User Avatar
Hello, Good-Day, I can create one template in excel sheet where you can find list of SKUs with Qty>0 that are on both input reports. I will provide you one excel template/automation/macro you just need to click on start button and instruction will run and generate results of SKUs with Qty>0 that are on both input reports. I work as full time freelancer and have 5 years of experience in this field. I can reliably work on daily basis and perform the task as per your instructions. Check my reviews to get an idea about my work. I'm online at the moment, feel free to initiate a chat; we can discuss further regarding your project. Thanking you, Regards, Parvez
$110 USD in 1 day
5.0 (2 reviews)
1.8
1.8
User Avatar
I've 13+ years of experience on MS Excel / MS Access wtih VBA/Macros experience. People call me as excel expert/specialist. I'm from from SCM --> Procurement background with BOM/SKU and cost managment experience with multiple spend and savings analytics. I've done similar projects in past. I'm glad to deliver this project assignment within given time frame and I can be a best asset for all your future projects too.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will finish the job and it will be done well. I am a Finance Executive with a career of experience with Excel and VBA.
$200 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Bridgewater, United States
5.0
1
Payment method verified
Member since Jan 18, 2021

Client Verification

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.