Find Jobs
Hire Freelancers

excel warehouse inventory and delivery management

$30-250 USD

Closed
Posted over 7 years ago

$30-250 USD

Paid on delivery
I need someone who can create an excel based delivery and inventory management system. I run granite and marble warehouse and need a way to better track deliveries and current warehouse inventory. I would like a system that would allow me to choose a customer name from a drop down box that would then auto fill the address, phone number and other contact information. then allow me to choose a material from a drop down box based on my current inventory in stock that would auto update the next pull down box with information relevant to the material chosen (lot number and number of slabs available). basically i need a way to quickly add and update new inventory and then automatically take it out with a delivery function that pulls information from a customer spreadsheet and the inventory spreadsheet.
Project ID: 12042573

About the project

27 proposals
Remote project
Active 7 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
27 freelancers are bidding on average $166 USD for this job
User Avatar
Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and commented, client gets whole access and rights for the code I made. Warranty covers any bugs detected later. Looking forward for further clarifications of the details. Regards, Sergey
$145 USD in 7 days
4.9 (7 reviews)
4.4
4.4
User Avatar
I have developed various inventory system for industries in MS Access. This has advantage of temper free and user friendly. However, if you have liking for Excel, I can develop the same as per your requirement. It will have all the features desired by you. I am Mechanical Engineer, proficient in Excel Macro, Pivot Table/charts with slicer, dashboard, functions and formulas. About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, Production and IT Excel Expert Group Member Access Expert Group Member Proficient in Google Sheet Worked on Macro, VB, Pivot, User Form, Google Sheets Proficiency in Office tools, SAP, AutoCAD, 3DMax, Coral, Qualification- Mechanical Engineer Available on Skype Some Projects: Developed complete ERP system for Marketing in DB4 (earlier to Access) SAP implementation as Key Coordinator Community Survey (Near 10 Million Data compilation) in Excel Industrial Project Report in Excel Multilingual Kazien Sheet in Excel with VB Offer Preparation in Access Project Planner in Excel Very Large Database Analysis Completed few Contests at Freelancer For Details of my Work 1. Please see my profile 2. Please see Services offered by me. If you initiate dialog, I can submit samples of my work. It will be pleasure working for you. I believe in Customer Delight.
$155 USD in 5 days
3.9 (9 reviews)
3.5
3.5
User Avatar
i have been working for 10 years data entry in multi- national company and i am using excel sheet you feel free contact
$35 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a hard working individual with the ability to follow instructions carefully and I have a determination to submit my work on time all the time. I have experience with working with any of the Microsoft office products and I will ensure that the client is satisfied with the quality of my work all the time
$211 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
This could be done in Excel yes (sort of) but would be difficult to manage or even maintain. Would a web solution that allows customers to track their orders too be better in the end? Let us know your thoughts however, as it does sound intriguing Many Thx -Brian
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! I want to infrom you that i am working on excel sheet from 2 years. So i think i will be perfect candidate for this work. I will give my sample excel work by your request. Thank you.
$88 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir, I read your job description very carefully and I believe I am very qualified for your project. I can start your project immediately and finish your project successfully within given time-frame with high quality. Trust me sir , it's very easy to me and I can give you a better service than other . I am confident about my skills & experience . so you should hire me or contact me any time so we discussed about your project more .
$30 USD in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I suggest to use MS Access on your inventory and delivery management because MS Excel is limited in handling records and I believe that it is not design for database application. But I assure you I can help make your database just give me the table and data to appear on each table you needed. I will make simple and usable for you.
$222 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have well hand on experience in this, if i will get this opportunity i can assure you that you will get quality work result on time...feel free to contact
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would propose to make an Access data base for you which will be much more effective in tracking your inventory as well we your customers. There would be three tables as under: 1. Products / items - list of all type of marble / granite you store (this could be categorized as per size , color, supplier, etc.) 2. Customers - all details of customers 3. Inventory transaction - this will be having details of incoming as well as outgoing inventories 4. You can also have one more table to keep details of your suppliers If you have an excel sheet with current data, I can create necessary tables from these sheets and make a prefect database to suit your requirements. You can also do then some analysis of your products e.g. which product is moving fast, which is slow moving, etc. your future orders can also be planned based on such analysis. Database will have a lot of possibilities to enhance your business.
$160 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
good afternoon I saw your project and I find it good and understandable. I have experience with that kind of work and i am ready to work. Please contact me so we can talk about the work. regards Jure
$222 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am professional in excel and designing account management system.
$120 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, This is Ravikumar Rangabashyam, I Hope i can do this Project with in your Lead Time. This is Possible in Excel sheets and explanation also i can give after did this project. Thanks & Regards, Ravikumar R +91 8754598859
$133 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Sir, I sent you a proposal for your required job. I hope you will accept me for this job. I am fit for this work. i shall wait for your response.
$166 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I had experience working as Inventory/ Stock controller. So I understand wha you needed. Regards, Annie
$222 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have long term experiences with work in Excel as typing datas and created tables. I like help you with your projects too. Regards Dusan Dorazil
$155 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would like to offer you my service. I used to do data entry and excel work. I can do it as your requirement and time that you want.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Myself Manish, I am a CPA / CA and MBA ( Finance ) having more than 5 years of experience. I am working as a Bookkeeping / Financial Consultant from last 5 years. As a financial consultant i supposed to handle all financial matters. For Ex - Accounting, budgeting and Finacial Planning etc. Also my family business is marble and granites so i have better understanding of the inventory. I have also work on such projects previously also so I can help you to create a proper excel sheets which help you to maintain your inventory Looking forward to work Thanks Manish
$150 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I constantly work in Excel where I need to pull in data from multiple other spreadsheets or sources.
$138 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have been working in the inventory management role for 5+ years. I would be able to help you surely if I get to know more details of the outcome that is required.
$150 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
chennai, India
0.0
0
Member since Jan 24, 2016

Client Verification

Other jobs from this client

Get Data Entry Done
$250-750 USD
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.