Find Jobs
Hire Freelancers

Master VBA coder needed to work on existing project

$2-8 USD / hour

Anuluar
Postuar about 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..
ID e Projektit: 16080530

Rreth projektit

12 propozime
Projekt në distancë
Aktive 6 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
12 freelancers are bidding on average $18 USD/orë for this job
Avatari i Përdoruesit
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 në 20 ditë
5,0 (549 përshtypje)
8,1
8,1
Avatari i Përdoruesit
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 në 5 ditë
5,0 (186 përshtypje)
6,7
6,7
Avatari i Përdoruesit
Hi there, I'm an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks
$44 USD në 10 ditë
4,9 (151 përshtypje)
6,4
6,4
Avatari i Përdoruesit
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 në 40 ditë
4,9 (41 përshtypje)
6,0
6,0
Avatari i Përdoruesit
I can do it for you quickly and exactly.
$10 USD në 20 ditë
4,9 (87 përshtypje)
5,9
5,9
Avatari i Përdoruesit
Excel and VBA expert with advanced VBA skills and experience of over 8+ years. Should be able to deliver as needed. Thanks
$22 USD në 40 ditë
4,9 (62 përshtypje)
5,3
5,3
Avatari i Përdoruesit
mphill in computer science
$7 USD në 1 ditë
4,8 (17 përshtypje)
4,9
4,9
Avatari i Përdoruesit
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 në 30 ditë
5,0 (8 përshtypje)
3,9
3,9
Avatari i Përdoruesit
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 në 10 ditë
5,0 (21 përshtypje)
3,9
3,9
Avatari i Përdoruesit
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 në 40 ditë
5,0 (2 përshtypje)
1,9
1,9

Rreth klientit

Flamuri i UNITED STATES
Elmsford, United States
4,8
82
Mënyra e pagesës u verifikua
Anëtar që nga qer 10, 2013

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.