Find Jobs
Hire Freelancers

I need an excel/vba expert

$30-250 USD

Đã đóng
Đã đăng vào khoảng 6 năm trước

$30-250 USD

Thanh toán khi bàn giao
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.
Mã dự án: 16294406

Về dự án

41 đề xuất
Dự án từ xa
Hoạt động 6 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
41 freelancer chào giá trung bình $147 USD cho công việc này
Avatar người dùng
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 trong 3 ngày
5,0 (852 nhận xét)
9,2
9,2
Avatar người dùng
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 trong 3 ngày
5,0 (483 nhận xét)
8,0
8,0
Avatar người dùng
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 trong 3 ngày
4,9 (266 nhận xét)
7,1
7,1
Avatar người dùng
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 trong 3 ngày
5,0 (178 nhận xét)
6,9
6,9
Avatar người dùng
Hello friend, I am well versed in excel. I can help you with this. Looking to hearing from you. Kind regards
$200 USD trong 3 ngày
5,0 (117 nhận xét)
6,5
6,5
Avatar người dùng
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 trong 3 ngày
5,0 (116 nhận xét)
6,6
6,6
Avatar người dùng
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 trong 3 ngày
5,0 (23 nhận xét)
5,7
5,7
Avatar người dùng
- 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 trong 5 ngày
4,7 (49 nhận xét)
6,1
6,1
Avatar người dùng
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 trong 3 ngày
5,0 (32 nhận xét)
5,4
5,4
Avatar người dùng
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 trong 3 ngày
4,8 (24 nhận xét)
4,9
4,9
Avatar người dùng
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 trong 20 ngày
4,9 (27 nhận xét)
4,8
4,8
Avatar người dùng
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 trong 4 ngày
5,0 (8 nhận xét)
3,9
3,9
Avatar người dùng
A proposal has not yet been provided
$100 USD trong 2 ngày
5,0 (2 nhận xét)
3,0
3,0
Avatar người dùng
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 trong 3 ngày
5,0 (5 nhận xét)
2,6
2,6
Avatar người dùng
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 trong 2 ngày
4,9 (3 nhận xét)
2,3
2,3
Avatar người dùng
A proposal has not yet been provided
$250 USD trong 7 ngày
5,0 (1 nhận xét)
1,7
1,7
Avatar người dùng
A proposal has not yet been provided
$200 USD trong 3 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
Posso criar uma pasta pra você e te ajudar a reorganizar seu inventário.
$155 USD trong 3 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
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 trong 3 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
....................................................................................................
$133 USD trong 2 ngày
0,0 (0 nhận xét)
0,0
0,0

Về khách hàng

Cờ của UNITED STATES
United States
0,0
0
Thành viên từ thg 2 14, 2018

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.