Find Jobs
Hire Freelancers

I need an excel/vba expert

$30-250 USD

Closed
Posted about 6 years ago

$30-250 USD

Paid on delivery
I need to build an excel sheet/workbook that allows me to easily manage my inventory and retrieve item status. For example, let's say I specialize in repairing motorcycles. At any given time I may have 20 to 30 motorcycles in my shop. Each motorcycle may at a different stage int the repair process, everything from new work order to parts waiting, mechanical repairs in process, and ready for delivery. I'm thinking about building a workbook with multiple sheets, a user input sheet, where I can input a VIN or stock number and receive an output of the STATUS of the motorcycle. A second and third sheet can be used as a database which is updated daily by the user with status changes and new inventory. As long as the database sheets are maintained properly, sheet #1 should output current status information for the user everytime a VIN or stock number is entered.
Project ID: 16294406

About the project

41 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
41 freelancers are bidding on average $147 USD 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
$210 USD in 3 days
5.0 (852 reviews)
9.2
9.2
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$200 USD in 3 days
5.0 (483 reviews)
8.0
8.0
User Avatar
I am fast and Extremely Detailed Oriented and good with Excel and EXCEL MACRO/VBA. Completed more than 150+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in Sales, Marketing and Advertising. Currently I am working for a Multinational Telecommunication Company as an B2B Marketing Manager.
$200 USD in 3 days
4.9 (266 reviews)
7.1
7.1
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered nine excel vba projects in the past 45 days. Willing to take up your project. Thank you, Regards.
$155 USD in 3 days
5.0 (178 reviews)
6.9
6.9
User Avatar
Hello friend, I am well versed in excel. I can help you with this. Looking to hearing from you. Kind regards
$200 USD in 3 days
5.0 (117 reviews)
6.5
6.5
User Avatar
Dear Employer, I'm ready to work on "excel vba sheet workbook" project. Relevant Skills Excel, VBA Milestones 129 USD - code writing 32 USD - userfriendly interface I can complete your project on time and within your budget.
$161 USD in 3 days
5.0 (116 reviews)
6.6
6.6
User Avatar
Hi, I have over five years experience in using Excel at an advanced level (formulas, macros, automatic calculation sheets) as an Industrial Engineer at Michelin. I am always keen to improve my work quality and productivity and I made complex Excel sheets to automate my tasks. I will be pleased to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
$100 USD in 3 days
5.0 (23 reviews)
5.7
5.7
User Avatar
- This would be a solution for inventory of parts and status of vehicles. - Like going with your example if you have 20-30 vehicles which being serviced.... each vehicles could have multiple works in progress, pending Yet to start. - Similarly part numbers used from stock, waiting for purchasing. - If you have already have a list of part numbers in which the inventory is maintained as the parts are used you can know how much is balance as of today, thereby initiating a purchase order for the part request. - In the front page we could have have overall summary of each vehicle or get detailed status of one vehicle so that you could know at a glance your overall position and accordingly confirm the dates with customer. - The solution could be finetuned based on how we envision the overall output. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Can
$300 USD in 5 days
4.7 (49 reviews)
6.1
6.1
User Avatar
I am an Australian business analyst with 15 years professional experience building complex solutions using Excel and VBA / macros (and a love of motorcycles, after joining my partner on his bike trip from Australia to Ireland). I have built a number of similar work tracking solutions in Excel, and have a background in retail planning, so am very familiar with inventory management processes. I would love to chat further about your project.
$155 USD in 3 days
5.0 (32 reviews)
5.4
5.4
User Avatar
I will make a db management system in Excel complete with user input sheets, current status sheet and summary sheet. Forward me details in a personal message
$155 USD in 3 days
4.8 (24 reviews)
4.9
4.9
User Avatar
Hi - Excel as a choice of technology does not sound to be a best idea here. What you probably need is a web based application that probably you can operate from your mobile or tab too. Here are my reasons: 1) If excel gets corrupted, you have a problem 2) System can be accessed only from one machine. While you can make copies reconciliation will be a painful effort when parallel updates are made. 3) Enhancement to other interfaces becomes difficult in excel. When you build it over a database you get complete control to even build an app at a later point 4) If you build a web based system in the long run you can even allow your customers to view the status of their vehicle. While building this in excel is not really a big deal, i thought i'll highlight the advantages of going for a full fledged system. I hear your mind voice that it would be expensive which i agree to. But there are open source options like odoo which i would recommend. Good luck.
$250 USD in 20 days
4.9 (27 reviews)
4.8
4.8
User Avatar
Dear Hiring Manager, I am an expert in excel and have worked on various automation projects. 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
$223 USD in 4 days
5.0 (8 reviews)
3.9
3.9
User Avatar
A proposal has not yet been provided
$100 USD in 2 days
5.0 (2 reviews)
3.0
3.0
User Avatar
Hi, I am an excel and VBA specialist , I see what you want and I can create the excel file in 2 or 3 days. you can pay me for the project after I finish it.
$133 USD in 3 days
5.0 (5 reviews)
2.6
2.6
User Avatar
Dear, I have extensive experience developing Excel, I have made similar applications, I can make the application you need, I just need an excel sheet with the information you want to store your business, I can start the development immediately if you need it, I am attentive to your comments, kind regards
$90 USD in 2 days
4.9 (3 reviews)
2.3
2.3
User Avatar
A proposal has not yet been provided
$250 USD in 7 days
5.0 (1 review)
1.7
1.7
User Avatar
A proposal has not yet been provided
$200 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Posso criar uma pasta pra você e te ajudar a reorganizar seu inventário.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We are agroup of proffessional in each flied in the services we offer to you We are Ready to help at your request with no excuse We brand value for money to every Client We do not work and others work The Key Work Smart Competition is our Driver What we can not Do only is what you have not given us
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
....................................................................................................
$133 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Feb 14, 2018

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.