advance excel coder neeed - project for Anjaneya Sastry K.

I have a live workbook that now requires true automated reporting. I want every key metric to refresh in one click (or on a scheduled trigger), compile into clean summary sheets, and export to PDF without manual touch-up. The data structure and layout are already in place; what’s missing is the VBA / Power Query logic, dynamic named ranges, and any other advanced techniques you feel will keep the process bullet-proof as volumes grow. Here’s what success looks like to me: • Press a button (or let the timer run) and the raw data is pulled, cleaned, and loaded. • Summary tabs instantly show updated figures and ready-to-print pages. • Optional but welcome: interactive dashboards and charts for quick visual checks. You’ll receive the current workbook plus a short spec describing the fields that feed each summary. Please bring strong Excel automation experience, tidy code habits, and the willingness to walk me through any custom functions so I can maintain them later.

Project ID: 40208955