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.
43 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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.
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
'm the author of this book (VBA and VB .NET): [login to view URL] 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.