Hi, I have experience in automotive spare parts and inventory.I did modules in this issue including Do you want to implement a module in Microsoft Excel? seems to me that you have more items then excel can hold in one workbook. So it is important to know how much items spare parts you need to keep in a database.
I am a professional financial and a guru in Excel and VBA. I create creative and sophisticated financial & statistic models in a simplified and logical manner. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. More on that, I develop financial modules including business valuation methodology & ratios. Also, I have experience in accounting, Financial Report Tools.
I offer you 35+ years of experience working in a variety of companies including, VC's, privet investors, entrepreneurs, startups, marine and land transportation, retailers, power plants, farms, insurance, universities, real estate & constructions, medical equipment manufacturer, among others.