Hi, I did similar projects which manage projects and their costs including labours, equipment, materials and subcontractors. there is an option to add external cost lists. The user fills a form and excel shows complete order/question, and by one click, converts it to PDF file and at the same time, updates the order/question in the primary database with the other reports as well.
There is a search engine with high search capability to find specific information. You will be able to get reports and chart like Project Status and by other indicators. During the reporting process, Excel validates the information and prepares reports and documents based on the needed parameters and criteria. There is a report generator which enables to develop templates independently.
About me
I am a financial expert and guru in Excel/VBA/Macro. 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 have experience in financial reports, accounting, consolidating, forecasting, budgeting and cost acquisition based on inventory, bill of materials, collections, payments, and bank reconciliation.