I am building a simple Excel Inventory Database to capture Laptops and Desktops coming in and out of Store Room.
We be using a Barcode scanner to scan the Serial Number on the Machine onto an Excel Form and input additional details on the form. Before this record is saved inside the Inventory Databse(Excel Worksheet).
This Form will serve 2 purpose, Machines coming into the Store, and Machines moving out of the store. The same Serial Number will be scanned using the Scanner on the Form.
So i basically need a VBA Forms for Moving In and Moving Out(with additional data to be inputted). The VBA form will dynamically query my Inventory Table and Insert and Update data accordingly.
I would need an Audit Log of all Entries that are recorded
I am currently on a tight schedule and not able to program this VBA myself hence need someone to program this for me.
Additional requirement : I will like to have a feature whereby I am able to email an Acknowledgement Email to the Person that I receive the Machine or Issue out the Machine too.
I have created the Sample form designs with the necessary fields.
I would need delivery of this project in 1 Day.
17 freelancere byder i gennemsnit $45 på dette job
Hello i'm developer with rich experience in ms excel and vba macro please see my portfolios in excel, already i have done the same project best regards
I can do this application whatever you want with a nice interface and the database will be updated every new coming and every out of computer or what you are solding
Hi I'm interested in this opportunity. I have good experience in it. I xam deliver you the work in less time and with minimum amount charged. Thanks Sneha