Excel Data Automation Script

My workbook is updated entirely by hand right now, and those repetitive steps are starting to slow the rest of my workflow down. I’d like a clean, reliable automation layer—whether that’s VBA macros, python, Power Query, or another approach you recommend—that takes the manual touch-points out of the process. Key points • The file is currently maintained manually; every update, refresh, and calculation depends on me. • I want a single-click (or similarly simple) routine that imports fresh data, applies the required transformations or calculations, and leaves the workbook ready for immediate use. • The solution should run inside Excel (no external paid tools) and be easy for a non-technical user to maintain. Please let me know: 1. Which method you propose (e.g., VBA, Office Scripts, Power Query). 2. How you’ll structure the workflow, so future edits remain straightforward. 3. An estimated turnaround time once you have access to a sample file. Deliverable: the automated workbook plus any commented code or documentation needed so I can adapt it later.

Project ID: 39729782