Find Jobs
Hire Freelancers

I need an excel/vba expert

$30-250 USD

Zavřený
Zveřejněno přibližně před 6 roky

$30-250 USD

Zaplaceno při doručení
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.
IČ projektu: 16294406

O projektu

41 nabídky
Vzdálený projekt
Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
41 freelanceři nabízejí v průměru $147 USD za tuto práci
Avatar uživatele
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 v 3 dnech
5,0 (852 recenze)
9,2
9,2
Avatar uživatele
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 v 3 dnech
5,0 (483 recenze)
8,0
8,0
Avatar uživatele
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 v 3 dnech
4,9 (266 recenze)
7,1
7,1
Avatar uživatele
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 v 3 dnech
5,0 (178 recenze)
6,9
6,9
Avatar uživatele
Hello friend, I am well versed in excel. I can help you with this. Looking to hearing from you. Kind regards
$200 USD v 3 dnech
5,0 (117 recenze)
6,5
6,5
Avatar uživatele
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 v 3 dnech
5,0 (116 recenze)
6,6
6,6
Avatar uživatele
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 v 3 dnech
5,0 (23 recenze)
5,7
5,7
Avatar uživatele
- 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 v 5 dnech
4,7 (49 recenze)
6,1
6,1
Avatar uživatele
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 v 3 dnech
5,0 (32 recenze)
5,4
5,4
Avatar uživatele
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 v 3 dnech
4,8 (24 recenze)
4,9
4,9
Avatar uživatele
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 v 20 dnech
4,9 (27 recenze)
4,8
4,8
Avatar uživatele
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 v 4 dnech
5,0 (8 recenze)
3,9
3,9
Avatar uživatele
A proposal has not yet been provided
$100 USD v 2 dnech
5,0 (2 recenze)
3,0
3,0
Avatar uživatele
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 v 3 dnech
5,0 (5 recenze)
2,6
2,6
Avatar uživatele
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 v 2 dnech
4,9 (3 recenze)
2,3
2,3
Avatar uživatele
A proposal has not yet been provided
$250 USD v 7 dnech
5,0 (1 recenze)
1,7
1,7
Avatar uživatele
A proposal has not yet been provided
$200 USD v 3 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Posso criar uma pasta pra você e te ajudar a reorganizar seu inventário.
$155 USD v 3 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 v 3 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
....................................................................................................
$133 USD v 2 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z UNITED STATES
United States
0,0
0
Členem od úno 14, 2018

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.