Automated Excel Reports & Charts
₹400-750 INR / hour
Posted 1 minute ago
•
Ends in 6 days
₹400-750 INR / hour
Each week I receive a fresh CSV-style export from our internal database. I want to drop that file into a folder and have Excel do the rest—import the data, refresh the model, and output a ready-to-share report that looks exactly the same every time. No buttons, no manual steps, just an automatic trigger when the new export appears. Scope • Build an Excel workbook (Power Query, Power Pivot, or VBA—whatever you feel is most robust) that detects a newly added export file, pulls in the data, applies any required transformations, and updates all linked pivot tables and charts. • Structure the workbook so the summary sheets and visuals mirror the layout we already use in our manual reports. • Include a simple way for me to change the export file path if our system folder ever moves. • Final deliverables: the automated workbook, a one-page setup guide, and a brief walkthrough call to confirm everything runs hands-free on my machine. Acceptance criteria – Dropping a new export into the designated folder automatically refreshes every table and chart without further input. – No hard-coded file names; the solution should recognise the latest file in the folder. – Processing time per file under two minutes on a standard office laptop. – Output matches the current manual report exactly in content and formatting. If this sounds straightforward to you and you’re confident with Excel automation, let’s get the workbook humming.
Project ID: 40813052
About the project
2 proposals
Open for bidding
Remote project
Active 9 secs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
2 freelancers are bidding on average ₹545 INR/hour for this job


Hi there I am an experienced Excel automation and data processing specialist with a strong background in Power Query, Power Pivot, and VBA. I can build a fully automated Excel workbook that automatically detects new CSV or database exports dropped into your designated folder, processes and transforms the data, and updates all linked pivot tables and charts without requiring manual buttons or steps. I will configure the folder path to be fully dynamic so it can be easily updated if your directory changes, ensure the output precisely mirrors your current manual report layout, and deliver a clean one-page setup guide alongside a walkthrough to confirm smooth execution on your machine. Best regards Ammar
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗