Hello! Please share a sample file to take a look.
I am an engIneer and Excel/VBA/Macro expert and Google Scrpit , Google Sheets expert too. 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 (script).
Regards,
Juan