Closed

Excel sheet Inventory tracking (daily, weekly, monthly)

I have a small business that i need to create a excel workbook to keep track of few things regarding daily/weekly/monthly events. I have few delivery drivers that each day they would load the truck, take it out and make sales. Now when they pick up their inventory they fill out a sheet, with information like their name, truck #, inventory that they took in etc....and at the end of the day they fill out the inventory that went out, at what price, the amount they made, inventory returned etc.

On tab 1 i have a mock up of the slip that the drivers fill out, one of the employees will need to enter the slip information into the Tab 1 in excel and then i need to have a button that they can press (macro, vb code i doesnt matter) but once the button is executed the information from the tab 1, will need to be saved onto different tabs in this excel sheet depending if its Inventory, dollar amount, drivers, etc...

so the project consist of one input sheet with a macro to save the information into the other tabs in database format.

I have the excel set up already with the tab 1 and information that needs to be on there, the other tabs i have set up as well with also the final tab that is mostly calulations of previous tabs and that will give me the final inventory, inventory sold, overage/shortage etc...

Please let me know the price and timeframe on this project.

thanks

Skills: Data Processing, Excel, Visual Basic

See more: daily inventory sheet excel, daily inventory excel sheet, daily inventory excel, inventory excel sheet, track daily inventory excel, daily inventory tracking sheet, excel sheet daily inventory, inventory tracking sheet, inventory tracking excel sheet, monthly inventory sheet, inventory tracking sheet excel, inventory shortage excel tracking, tracking inventory daily excel, excel sheet inventory tracking, weekly inventory excel, daily weekly monthly inventory, monthly inventory excel sheet, tracking daily inventory excel, monthly inventory sales excel, excel daily weekly sales, excel monthly inventory, track inventory daily, tracking inventory sheet, weekly inventory sheet, inventory daily excel

About the Employer:
( 1 review ) Rensselaer, United States

Project ID: #1158648

45 freelancers are bidding on average $93 for this job

bharanisrihari

Hello, Excel VBA expert here. I've done a similar project already. Please see PM for details. Thanks!

$150 USD in 5 days
(64 Reviews)
6.5
Krusche

Please check your PMB

$120 USD in 2 days
(29 Reviews)
5.6
mrbrave

Ready to start now...

$40 USD in 1 day
(67 Reviews)
5.3
nagybatonyi

Such jobs are my daily practice, please see PMB for details! Regards!

$70 USD in 2 days
(38 Reviews)
5.3
rodelacidera

Hi, please check PMB, regards

$120 USD in 7 days
(6 Reviews)
4.4
telemarketing555

Hi, please check your PM. Thank you.

$150 USD in 5 days
(25 Reviews)
4.4
psprongs

Please check PMB

$50 USD in 2 days
(10 Reviews)
4.3
faialeem

Hi Please Check your PM for Detail

$100 USD in 3 days
(13 Reviews)
4.0
rjmijares

Please see PM message of my bid.

$150 USD in 5 days
(3 Reviews)
3.2
jacoby

Dear Slickdeal, I am experienced excel expert and professional accountant and quite interesting in your project. Please check pm. Thanks. Jacob

$90 USD in 3 days
(1 Review)
2.0
BGTServices

100% Satisfaction Guaranteed. Please see PM.

$100 USD in 1 day
(2 Reviews)
1.6
PG89

Hi, Check PMB

$80 USD in 2 days
(2 Reviews)
1.6
cau83

Go to this page at my website to view a demo that I would modify for your purposes: http://chrisumphlett.com/?p=68 . I would set up the pages/entry for your logistics purposes, rather than a bookkeeping/accounting p More

$150 USD in 7 days
(1 Review)
1.4
apatel7777

hi sir pratik here plz check your pm

$60 USD in 3 days
(1 Review)
1.0
waqasaliahmad

I am working in an organization where we have to do alot of such type of work. If i am given the opportunity, i will try to deliver it as perfect as it can be.

$60 USD in 2 days
(0 Reviews)
0.0
WilliamMemon

we keep 5 year experience in the same field. we provide our client top quality with charging low price.Hope for Good New. Best Regards.Memon

$80 USD in 12 days
(0 Reviews)
0.0
salman848

I can help you.

$80 USD in 2 days
(0 Reviews)
0.0
HelpfulBrain

Dear client Hire me. Thanks.

$120 USD in 3 days
(0 Reviews)
0.0
huzaifaahmed

Hello: Take the work of an expert currently at Ernst & Young (one of the big four chartered accountant firms) dealing routinely with different data processing systems such as SAP and ORACLE. Give and just get it More

$50 USD in 2 days
(0 Reviews)
0.0
sirishkumar6

hi.. i agree with our job work...

$90 USD in 3 days
(0 Reviews)
0.0