Excel-Driven Sales Summary Automation

Заказчик: AI | Опубликовано: 11.09.2025

I have an Excel workbook that stores our sales data and I need a reliable way to turn that information into a clean Word data-summary document. For this first phase I only need the total-sales figure pulled, formatted, and dropped into a Word file each time the workbook is updated. Here’s the flow I picture: the script or macro reads the latest sales numbers in Excel, calculates the grand total (no product or regional breakdowns yet), and then creates or refreshes a Word document with that single headline metric clearly presented. The process should run at the click of a button—or automatically if you think Office Scripts, VBA, or Python with openpyxl / python-docx would be smoother. Deliverable • A reusable script, macro, or add-in that generates the Word summary from the Excel source • A brief read-me so I can adjust the file path or change cell references later on If the solution is set up properly and the total-sales value in Word always reflects the latest sheet, I’ll consider the task complete.