Find Jobs
Hire Freelancers

Master VBA coder needed to work on existing project

$2-8 USD / hour

Cancelled
Posted over 6 years ago

$2-8 USD / hour

For 2 years now I have been fortunate enough to have 1 single coder working on an excel file that we developed to help us create our daily inventory xls file that we use for uploading to our database. This coder has recently become unavailable and my client is seeking some changes to the file. I need someone who doesn't mind working on teamviewer, as you will be connected to my pc when you work on this file. The issue we are having is complicated and requires someone who can fully immerse himself into the problem with me, then find the solution. This project is on urgent deadline and I must deliver asap. The issue we are having is that every product must have a SKU number on our database. We have 2 pages. 1 sheet we use for Specials products with bulk product quantities. The second sheet is used for Products regular pricing. We have to add all our products to a sheet. Then once we have added all products, we run a command Save for Web. When we run that command, every product we added to the respective sheets gets a sku pulled from a master file called SKUS.xlsm. We have two product types. Lot products and non lot products. Lots basically means the product is sold in bulk quantities. The problem we are having is that since we have NON LOT skus and LOT skus for the same product, when our command is being run to pull the skus, the skus on SHEET 1 come CORRECT, but the SKUS on SHEET2 come with LOT numbers. The coder on this project says this is caused because of an error related to having * in the product name. I normally give him ALL the time in the world to solve these problems, but he's not being very responsive as of late, and my client is hounding me to get this task complete. This is not for someone who's just beginning working on Excel. This is for a VERY advanced Excel VBA coder..
Project ID: 16080530

About the project

12 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
12 freelancers are bidding on average $18 USD/hour for this job
User Avatar
Hello Sir, Thank you for this opportunity. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Thanks, Jay
$26 USD in 20 days
5.0 (549 reviews)
8.1
8.1
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
$17 USD in 5 days
5.0 (186 reviews)
6.7
6.7
User Avatar
Hi there, I'm an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks
$44 USD in 10 days
4.9 (151 reviews)
6.4
6.4
User Avatar
Hi, I’ve read your proposal regarding daily inventory managing in Excel. I am highly qualified and have the relevant experience for this project.I am a professional financial and a guru in Excel and VBA, I manage inventory systems including physical stock (COGS), BOM, etc. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. More on that, I develop financial modules including business valuation methodology & ratios. Also, I have experience in accounting, Financial Report Tools. I served as CFO, Controller, and Chief Accountant at global parent companies, and I have extensive experience in accounting, consolidating, forecasting, budgeting, and costing I am a specialist in managing cash flow and liquidity solutions for the multi-currency environment and globally including collections, payments, inventory, and taxation. I offer you 35+ years of experience working in a variety of companies including, VC's, privet investors, entrepreneurs, startups, retailers, power plants, farms, insurance, universities, constructions, medical equipment manufacturer companies, among others.
$38 USD in 40 days
4.9 (41 reviews)
6.0
6.0
User Avatar
I can do it for you quickly and exactly.
$10 USD in 20 days
4.9 (87 reviews)
5.9
5.9
User Avatar
Excel and VBA expert with advanced VBA skills and experience of over 8+ years. Should be able to deliver as needed. Thanks
$22 USD in 40 days
4.9 (62 reviews)
5.3
5.3
User Avatar
mphill in computer science
$7 USD in 1 day
4.8 (17 reviews)
4.9
4.9
User Avatar
Dear Hiring Manager, I am an expert in excel and have worked on various automation projects. Also, I have experience working on macros created by others. My skills includes, but not limited to: Macros, Web Scraping, User Forms, Dashboards, Pivot Tables, Formulas, Customized Ribbon Buttons, Interaction with external applications for data exchange (Outlook, PDF, Access), etc. Regards Chintu
$7 USD in 30 days
5.0 (8 reviews)
3.9
3.9
User Avatar
Hello I have read and understood your description. I would love to help you on this project. I have experience on working on huge and complex VBA tools. One of the projects I recently had was that a client had purchased a workbook created by a web company as a tool, it included more than 20 macros with 100 lines of code each, and I had examined it so thoroughly that I could modify it per my clients request. Anyway, my point is I have the experience needed for this project, and I would love to help you. Don't hesitate to contact me with any question you might have. Thanks for reading, Michael.
$8 USD in 10 days
5.0 (21 reviews)
3.9
3.9
User Avatar
Available Immediately | Advanced VBA Expert | MS Excel Expert | Working on similar project which is comparable to what you have developed overall If interested, please feel free to message
$8 USD in 40 days
5.0 (2 reviews)
1.9
1.9

About the client

Flag of UNITED STATES
Elmsford, United States
4.8
82
Payment method verified
Member since Jun 10, 2013

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.