
Closed
Posted
I am ready to turn my current cost-estimation workbook into a fully automated financial-report generator. The objective is simple: with one click, Excel should gather the raw numbers I drop into source sheets, run the calculations, and present a polished financial report that’s formatted for printing and PDF export. Scope of work • Build VBA macros (and any supporting Power Query/PivotTable logic) that automate report generation. • Include a user-friendly form for key inputs such as date range, project code, and currency. • Populate a cost-estimation layout that aligns with standard financial-report structure. • Add robust data-validation and error-handling so no empty or duplicate entries slip through. • Leave the code clearly commented; I need to maintain and tweak it later. Acceptance criteria The macro must execute without errors in Office 365 desktop Excel, fill every field accurately, and complete the task in under five seconds on a dataset of roughly 10 000 rows. All raw data will reside in standard Excel tables—no external databases for now—yet the solution should be modular enough to accommodate new data sources down the road.
Project ID: 40537499
16 proposals
Remote project
Active 15 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average ₹1,556 INR/hour for this job

I have previously created similar excel and VBA based automtion tool to generate pdf report based on input data. Check details here - https://www.freelancer.in/portfolio-items/8690571-automated-real-estate-analysis I am an Excel & VBA Automation Expert with an MBA and 10+ years of experience delivering smart solutions to global clients (eg. Decathlon, E&Y, Schindler). I’ve successfully completed 100+ projects (4.9★ rating), helping businesses save time, reduce errors, and boost efficiency. FREE Consultation before Project Starts I can deliver a fast, accurate, and customized solution for your requirements. Let’s discuss your project—I can start right away. Looking forward to working with you!
₹750 INR in 40 days
5.9
5.9

Hi there, I will convert your cost-estimation workbook into a one-click Office 365 Excel generator using VBA, Power Query and PivotTables. I’ll add a user-friendly input form (date range, project code, currency), rigorous validation, clear comments, and modular code for future data sources. I will optimize performance to meet the 5-second/10,000-row target, deliver printable/PDF-ready formatted reports, and provide maintenance notes. Best regards, Wilfred
₹750 INR in 68 days
3.8
3.8

Hi Sir, I have seen your requirement for creating pdfs with your raw data inputs and perform top notch calculations. I can help you build an automated excel sheet with the help of Macors and AI knowledge we can get it done. I have previously worked on similar kind of works and provided full service. Please message me to discuss. Thanks Rana
₹750 INR in 40 days
3.8
3.8

Hello, Excel VBA Financial Report Automation Expert Antony here, Preferred Freelancer, Freelancer.com member since 2014, with 15+ years’ experience, 800+ verified reviews, and a money-back guarantee on originality and quality. I understand you want your cost-estimation workbook turned into a one-click financial-report generator that pulls raw table data, runs calculations, and outputs a polished print/PDF-ready report. I’ll build VBA macros, input forms for date range, project code and currency, validation for blanks and duplicates, error handling, optional Power Query/PivotTable support, and clearly commented modular code for future data sources. I can deliver a working prototype in 2 days, then finalize after testing your 10,000-row sample. I’ll include a FREE assumptions check and summary table. Should the report prioritize project-level totals or detailed cost-line breakdowns? Let’s open the first milestone and begin.
₹1,000 INR in 40 days
3.7
3.7

AM READY TO START ASAP: COST-ESTIMATION WORKBOOK AUTOMATION – ONE-CLICK FINANCIAL REPORT GENERATOR, VBA MACROS, POWER QUERY, DATA VALIDATION, ERROR-HANDLING, UNDER 5 SECONDS Hello, I am John K., MSc Econ & Statistician, 15+ years, 1,000+ projects, 4.9⭐. My expertise includes Excel VBA, macros, Power Query, PivotTables, data validation, and error-handling. My understanding is: You want your cost-estimation workbook automated into a financial-report generator. Objective: one-click gather raw data from source sheets, run calculations, present polished report for printing/PDF export. Tasks: VBA macros + Power Query/PivotTable logic, user-friendly form for inputs (date range, project code, currency), populate cost-estimation layout, add data-validation and error-handling, clear comments for maintenance. Acceptance: runs error-free in Office 365, fills all fields accurately, under 5 seconds on ~10,000 rows. I will deliver: ✅ A fully automated Excel workbook with one-click report generation. ✅ User-friendly input form and robust error-handling. ✅ Well-commented, maintainable code. I am ready to begin. Let's connect via chat to receive your current cost-estimation workbook. Respectfully, John K.
₹750 INR in 40 days
3.2
3.2

With a unique skillset that combines robust financial analysis, business planning, and data-driven decision making, I offer the ideal mix of talents for your project. Having crafted investment-grade financial models, valuations, and strategic plans for a diverse array of industries - from real estate to renewable energy - I possess extensive experience in creating complex Excel-based solutions. Automating your financial-report generator using VBA macros fits perfectly within my wheelhouse. I've consistently helped businesses make more informed decisions by delivering customized automated tools that are efficient, precise, and future-proofed. My thorough understanding of Excel combined with my specialized skills in Power Query and Pivot Tables ensure I can execute the scope of work perfectly by incorporating intelligent data-validation techniques to maintain dataset integrity. Moreover, I'm not only focused on technical proficiency but also on maintaining fluid and transparent communication throughout the project. This comes from years of producing executive-level PowerPoint presentations, reports, and briefs which demand concise, articulate representation of complex information. My code commenting approach will make it easy to navigate through the system post-project completion, saving you valuable time as your needs evolve. Let's connect to discuss how I could elevate your current report generation system beyond mere automation.
₹1,000 INR in 40 days
1.7
1.7

Hi there. I understand you need a highly stable, one-click VBA and Power Query architecture that ingests 10,000 rows of raw cost-estimation data, runs complex calculations, and outputs a polished financial report in under 5 seconds. While expanding my freelance presence here, I bring 14+ years of enterprise data architecture and VBA automation experience. To meet your strict <5-second execution limit, I will not rely on slow VBA loops. Instead, I will design a modular Power Query workflow to handle high-speed data ingestion and calculations, wrapped in a lightweight VBA User Form for easy inputs. Because I frequently build enterprise financial systems (visible in my portfolio), I will ensure the code is heavily commented, modular for future databases, and features robust data validation. Proof of Concept: To prove my code easily beats your 5-second limit, please send me a sanitized sample of your 10,000-row raw data via chat. I will immediately build a mock-up of the Power Query extraction logic and send you back a clean, calculated output completely free of charge before you commit to awarding the project. I am ready to start right now.
₹800 INR in 15 days
0.7
0.7

Hello, I can transform your existing cost-estimation workbook into a fast, one-click automated financial reporting solution using Excel VBA, Power Query, and PivotTables where appropriate. ✅ One-Click Report Generation ✅ Custom Input Form (Date Range, Project Code, Currency) ✅ Automated Financial Report & PDF Export ✅ VBA, Power Query & PivotTable Integration ✅ Data Validation, Duplicate Checks & Error Handling ✅ Clean, Well-Commented & Modular Code ✅ Optimized for 10,000+ Rows with Fast Performance With 7+ years of experience in Excel VBA automation and financial reporting, I've developed numerous automated reporting systems that eliminate manual work, improve accuracy, and generate professional reports in seconds. The solution will be scalable, making it easy to integrate additional data sources in the future. I'm ready to review your workbook and start immediately. Best Regards Ankit
₹750 INR in 40 days
0.4
0.4

Hi, I can build this as a capped first block: a one-click Excel financial report generator for your current cost-estimation workbook in Office 365. I work with Excel VBA and Power Query automation and would keep the workbook maintainable, not a black box. Bid: 1250 INR/hour, capped at 10 hours for the first week. What I would deliver in the first block: - Review current Excel tables, required calculations, date/project/currency inputs. - Build a VBA-driven report generation flow, with Power Query or PivotTable logic where useful. - Add an input form, validation for blank/duplicate records, and clear error messages. - Format the output as a print/PDF-ready financial report. - Test with around 10,000 rows and leave commented code plus short usage notes. Assumptions: raw data is in structured Excel tables and no external database is required in this first block. I will not process live/private files until the Freelancer hourly/project terms are active. If the workbook reveals larger scope, I will document it before expanding.
₹1,250 INR in 10 days
0.0
0.0

Hey! I build automated Excel financial report generators and your spec is solid — VBA + Power Query combo is exactly the right call here. What I'd deliver: UserForm with date range, project code, and currency selector Power Query pulling from all source sheets into a clean staging layer VBA macro that refreshes queries, runs calculations, and populates the report layout in one click Print-ready formatting + PDF export baked into the macro Full data validation — catches blanks, dupes, type mismatches before generation starts Modular structure so adding new data sources later is just plugging in a new query Every Sub and Function clearly commented for your own maintenance Tested against 10k rows, runs well under 5 seconds on Office 365 desktop. Code will be clean, commented, and yours to tweak freely. Ready to start immediately — what does your current source sheet structure look like?
₹750 INR in 40 days
0.0
0.0

New Delhi, India
Member since Jun 24, 2026
$250-750 USD
$30-250 USD
₹600-1500 INR
₹750-1250 INR / hour
₹600-1500 INR
$10-30 USD
₹600-1500 INR / hour
$10-30 USD
₹750-1250 INR / hour
€200-300 EUR
₹750-1250 INR / hour
₹1500-12500 INR
min $50 USD / hour
₹12500-37500 INR
₹12500-37500 INR
₹12500-37500 INR
$30-250 USD
$30-250 USD
$30-250 USD
$750-1500 AUD