Hi, I develop inventory modules in Microsoft Excel by VBA. I built modules which enable you to manage inventory transactions and Bill Of Materials in a spreadsheet and to get immediate reports and info. The modules can upload external databases. The modules show the transactions on user-form with a possibility to review and update them. There is a search engine with high search capability to find a specific record (or group of records). During the process, Excel validates the information and prepares reports and documents based on the needed parameters and criteria. There is a report generator which enables you to develop templates independently. And more, the files are secured by username login and password.
About Me:
I am a financial expert and a guru in Excel and VBA. 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. Furthermore, I develop financial modules including business valuation methodology & ratios.