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.
45 freelancers are bidding on average $93 for this job
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.