
In Progress
Posted
I have a growing customer-data workbook in Excel and I need it to produce clean, consistent reports every single day without manual intervention. The job is to enhance the current file with an automated workflow that: • Pulls in the latest customer records from the existing data table or an external source if linked • Refreshes any pivot tables, charts or formulas involved in the summary • Generates a polished report (Excel sheet and optional PDF export) at the press of a single button, or on an automatic schedule if practical • Saves the output to a designated folder with a date-stamped filename so I can archive results effortlessly Whether you choose VBA macros, Power Query, Power Pivot, or another native Excel approach, the end product should be easy for a non-technical user to maintain and extend. Clear inline comments and a brief hand-off note explaining how to adjust the reporting window or data range will be appreciated. Once everything runs smoothly and the daily report matches the existing manual version, the project is complete.
Project ID: 40573864
10 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hello. Let’s discuss this project……………………………………………………………………………………………………………………………………………………………………………………………
₹1,000 INR in 40 days
2.8
2.8
10 freelancers are bidding on average ₹1,040 INR/hour for this job

Hello I can automate your daily customer reports in Excel using VBA, pulling latest records, refreshing pivot tables and charts, generating polished reports, and saving them to a designated folder with a date-stamped filename, all at the press of a button or on a schedule, within your budget of 750-1250 INR hourly rate. Waiting for your response in chat! Best Regards.
₹1,000 INR in 3 days
5.3
5.3

I can enhance your existing workbook using VBA, Power Query, and native Excel features, depending on your current setup. The solution will automatically refresh the latest data, update pivot tables, formulas, and charts, generate the required report, and save it with a date-based filename in your preferred location. If required, the report can also be exported as a PDF without any manual steps. The workbook will be designed so future updates remain simple. I keep the code well organized, add comments where appropriate, and provide a short handover guide explaining how to modify the data source, reporting period, or output location without affecting the automation. Before final delivery, I will test the workflow thoroughly to ensure the automated report matches your existing manual process and runs consistently without errors. I would be glad to review your current workbook and recommend the most suitable approach before development begins.
₹750 INR in 160 days
2.9
2.9

Hi, I have 5+ years of experience in Excel, data processing, reporting, and automation. I can help streamline your workbook, automate report generation, refresh data, and create an easy-to-use reporting workflow. I am available to start immediately and would be happy to review the workbook details. Regards, Suraj
₹800 INR in 40 days
1.3
1.3

Hi, I reviewed your project: Automate Daily Customer Reports. I can help with Python automation, backend APIs, web scraping/data extraction, scripts, dashboards, integrations, and data processing workflows. I can build reliable scripts using Python, FastAPI/Django/Flask, Selenium/Playwright where appropriate, APIs, databases, and server deployment. Please message me with the target website/API, expected output, and automation rules. Portfolio: https://www.freelancer.com/u/irfanui Regards, Mohammad 4th Dimension Partners
₹2,384 INR in 44 days
0.0
0.0

Hi there, I am an automation expert with a strong background in developing efficient workflows for data management. I’ve reviewed your requirement for an automated customer-data reporting system and I am confident I can build a solution that is both powerful and easy for your team to maintain. My approach to your project: 1. Automation: I will implement a workflow using Power Query for data retrieval and VBA for report generation, ensuring the process is fully automated at the press of a button. 2. Maintainability: I believe in clean code. Every module will include clear inline comments, and I will provide a brief, non-technical hand-off guide so your team can easily adjust reporting windows or data ranges without needing coding knowledge. 3. Archive System: I will set up the automatic file-saving logic with date-stamped filenames as requested for effortless archiving. I have extensive experience in creating automated Excel workflows that mirror existing manual processes while eliminating the risk of human error. I am ready to start immediately to help you save time every single day. Best regards, Miyako L.
₹1,000 INR in 40 days
0.0
0.0

Hi, You need your Excel workbook to generate accurate daily reports automatically without manual work. I can enhance your existing file with a reliable automation workflow that refreshes data, updates reports, and saves everything in one click. What I will do: Automate data import and refresh Update pivot tables, charts, and formulas Generate Excel and optional PDF reports Save reports with date-stamped filenames Add clear comments and an easy handover guide What I will need from you: Existing Excel workbook Sample data/source details Current report format Output folder preference I’ll start by reviewing your workbook and reporting process, then build the automation using the most suitable Excel tools, test it against your current manual report, and deliver a simple, maintenance-friendly solution. Best regards, Akif K
₹800 INR in 2 days
0.0
0.0

With extensive experience in Excel automation and VBA scripting, I can enhance your customer-data workbook to generate daily reports seamlessly. I understand the need for a reliable automated workflow that updates records, refreshes pivot tables, and delivers polished reports effortlessly. My question: Would you prefer the automated reports to be generated at a specific time each day or upon manual initiation? Regards, mundadiya
₹916 INR in 32 days
0.0
0.0

As a software engineer and virtual assistant with over three years of experience, I have specialized in automating repetitive tasks similar to your project of streamlining daily customer reports. Having worked extensively with data analysis and Excel, I bring the requisite skills to enhance your existing workbook with an automated workflow. You can trust me to pull in the latest records from the data table or external sources and build customized pivot tables, charts, and formulas to deliver a polished report just at the click of a button. My approach aligns perfectly with what you're seeking - creating solutions that are easy for non-technical users to maintain and extend. This means I will not only automate your reports but also provide clear inline comments and a hand-off note explaining how you can adjust the reporting window or data range as desired. Moreover, my extensive experience covering numerous projects demonstrates my ability to deal efficiently and effectively with projects of any complexity - this will inevitably reflect on quality daily reports while saving you time and effort. Let's partner together to exceed your expectations for automated reporting while achieving improved efficiency in your business operations!
₹750 INR in 40 days
0.0
0.0

Roha, India
Payment method verified
Member since May 14, 2022
₹1500-12500 INR
₹600-1500 INR
₹600-601 INR
₹600-1500 INR
₹1000-3000 INR
$250-750 USD
₹750-1250 INR / hour
₹12500-37500 INR
₹600-1500 INR
₹1500-12000 INR
$10-30 USD
min £36 GBP / hour
₹400-750 INR / hour
₹750-1250 INR / hour
₹200-1000 INR / hour
₹400-750 INR / hour
$30-250 USD
₹1500-12000 INR
$25-50 USD / hour
$10-30 USD
₹600-1500 INR
$250-750 USD
$10-30 USD
$10-30 USD
₹12500-37500 INR