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.
45 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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
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.
'm the author of this book (VBA and VB .NET): [url removed, login to view] I conduct lectures and laboratory classes with students in the course “VBA and VB .NET”
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.