
Closed
Posted
I have an Excel workbook that needs to do more than hold raw numbers. Using IF, SUMIF (and similar) formulas, I want the file to: • filter my data on the fly, • run conditional calculations that adapt as new rows appear, and • roll everything up into clear, criteria-based summaries. Once that logic is solid, I also need a one-click way to export the relevant sheets—or a defined print range—straight to PDF. The export should preserve whatever structure the formulas create, so the numbers shown in the PDF always mirror the latest workbook state. If charts or additional tables are required to make the report clearer, please build those into the flow; I’d like the option to toggle them on or off without touching the underlying code. Deliverables: 1. A fully functional Excel file with the requested IF/SUMIF logic in place. 2. A streamlined PDF export routine (macro, VBA button, or native settings) that produces a clean, professional report. 3. Brief, plain-language notes explaining where to update criteria or add data in the future. Everything should be compatible with the current desktop version of Excel for Windows. If you’ve done similar dynamic reporting setups before, a quick sample screenshot would be helpful.
Project ID: 40747828
34 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
34 freelancers are bidding on average ₹915 INR/hour for this job

★★★ TOP 1% IN FREE LANCER WORLD ★★★ ★★★ 20+ Year Experience in IBD being CMD★★★ ★★★ 200+ Country Satisfied Clientele ★★★ ★Linkedin★ ★Data Entry★ ★Business Plans★★★ ★★★ Operational Strategic planner Customer Support 24*7★★★ ★★★Excel/Word Operation★★★ ★★★Chat Support★★★ ★★★Calling Support★★★ ★★★Business Plans / Marketing Strategy ★★★ * Digital Marketing★★★ ★★★Social Media Marketing ★★★ ★★★Internet Marketing ★★★ ★★★Any type of Data Projects★★★ ★★★★★★ Regards, ★★★CMD★★★ ★★★PVSYS GROUP (INDIA)★★★ ★★★IF YOU THINK THEN I CAN★★★
₹750 INR in 40 days
5.9
5.9

Hi there, The moment I read "Excel Automation & PDF Reporting", I knew it was a strong match for exactly what we do best. I don’t just want to tick the boxes here; my aim is to hand you something that genuinely goes beyond what you pictured. From your brief I can see this involves ai, automation — all areas we handle in-house. We specialise in Visual Basic, Data Processing, Excel, Software Architecture, which lines up directly with what you need. How we'd approach it: - Clarify the use-case, inputs and the exact output you expect - Build and integrate the model / automation pipeline - Evaluate accuracy and tune against real examples - Deploy with monitoring and a clear handover I also noted you don’t need touching the underlying code — that’s clear, and I’ll keep the work clean and strictly on-brief. Happy to work hourly with transparent time tracking and regular check-ins. You can count on tight communication, on-time delivery, and a result that’s effortless to sign off on. Happy to jump on a quick chat to walk through scope and timelines whenever suits you. Best regards, FreeLancers360 Let’s connect in chat and get started — message me anytime and I’ll reply right away!
₹750 INR in 7 days
3.8
3.8

With over four years of experience utilizing Excel for data analysis, processing, and automation, I am confident in my ability to fulfill your Excel Automation & PDF Reporting project requirements to the tee. My expertise in employing IF, SUMIF, and similar formulas will allow me to build a dynamic reporting system that enhances your data management and offers clear, criteria-based summaries. My familiarity with advanced Excel functions will enable me to create calculations that adapt smoothly as new data enters the workbook, giving you a comprehensive analysis across different variables. Moreover, my strong grasp on macros and VBA programming will ensure a streamlined PDF export routine that aligns with your demands of generating clean, professional reports reflecting the latest workbook states. In addition to my expansive range of skills and qualifications, I believe my emphasis on producing thorough documentation will be invaluable to your team. I am committed to delivering not only a fully functional Excel file and a PDF exporting mechanism but also concise instructions ensuring seamless future updates. I look forward to sharing a quick sample screenshot of the dynamic reporting setup I've previously implemented that simulates what we hope you could achieve from this project through my expertise.
₹1,000 INR in 40 days
3.2
3.2

Hey, No more long messages or proposal, i am the best fit to this project. Message me anytime and let's discuss your project! Cheers, Florence B
₹1,127 INR in 40 days
3.5
3.5

Hi, I can set this up: data in an Excel Table so the IF/SUMIFS formulas pick up new rows on their own, criteria-based summary sheets, and a small VBA button that exports the report range to PDF, with a cell to switch the charts on or off. I don't have a screenshot of a similar setup to share, to be honest, so I'll send you the summaries first and do the PDF part once you're happy with the numbers. I'd expect 4-6 hours in total. Quick question: which criteria do you summarize by (date, category, region...) and roughly how many rows? Greg
₹1,250 INR in 8 days
3.2
3.2

I will transform your Excel workbook from a simple raw-data file into a dynamic calculation and one-click professional PDF reporting system, where logic and summaries update automatically as new rows are added. Approach: I will use structured Excel tables and formulas (such as IF, SUMIF/SUMIFS) to implement criteria-based filtering, conditional calculations, and dynamic summaries. I will design the charts and tables to be toggleable without affecting the underlying logic. Using VBA macros or buttons, I will export selected sheets or defined print ranges as clean PDFs reflecting the workbook's latest state. I will validate formulas, page layouts, print areas, and PDF outputs by testing on Windows desktop Excel. Additionally, I will provide simple notes on how to modify criteria and add future data. Questions: 1. Is the existing workbook or sample data available? 2. Which sheets or sections should be included in the PDF? 3. Is a VBA macro acceptable for the export function? 4. Are there any preferred KPIs for the charts? I will deliver a maintainable, user-friendly, and fully tested Excel reporting solution.
₹750 INR in 40 days
3.6
3.6

As an experienced Excel and VBA developer, I believe I have the exact skill set you need for this project. I've spent a significant amount of time wrangling complex data in Excel and automating processes to save time and increase efficiency. I'm well-versed with the necessary formulas like IF, SUMIF and have experience making them adaptive to data changes. In terms of delivering your requested functionalities, I can confidently promise a well-organized workbook that dynamically filters your data based on your given criteria, continuously recalculating as new rows are added. Furthermore, exporting these filtered worksheets to PDF without losing the dynamic nature and structure is a task I've accomplished numerous times in my career.
₹750 INR in 40 days
2.5
2.5

I have developed automated reporting systems with dynamic formulas and PDF export. For an e-commerce project, I created a pricing engine based on conditional calculations, similar to your SUMIF. I can set up adaptive filters and pivot tables that update when new data is added. I implement PDF export using VBA while preserving the current state of the sheet. How do you plan to maintain the relevance of filtering criteria as the data scales?
₹1,250 INR in 14 days
1.5
1.5

With my extensive background in computer science and artificial intelligence, I am confident that I can deliver the excel automation and PDF reporting solution you need. Over my 20-year career, I have developed numerous advanced digital products that involve criteria-based logic, similar to what you're requesting. Notably, I have built AI-powered tools for document processing and data extraction which required a deep level of understanding in sophisticated programmings such as IF/SUMIF formulas. Lastly, proficiency in Visual Basic among other dynamic programming languages makes me well-suited to handle your project's Excel compatibility requirement. I look forward to discussing further how we can streamline your spreadsheets and create clear and dynamic PDF reports from your Excel sheets that integrate seamlessly with the latest workbook state.
₹750 INR in 40 days
1.1
1.1

I can deliver 'Excel Automation & PDF Reporting' end to end — clean architecture, tests, and deployment. I'll start with a short plan, share progress daily, and hand over production-ready code. Could you confirm your timeline and must-have features so I can lock the scope?
₹831.25 INR in 7 days
0.0
0.0

Hello, I can turn your workbook into a reliable, easy-to-update report. I will use Excel Tables and structured references so new rows flow into IF/SUMIF-based calculations and criteria summaries automatically. For the PDF, I will configure the correct print area and a one-click export using Excel's native export or a small VBA button, depending on your macro policy. I will test added rows and changed criteria, compare the PDF figures with the workbook, and provide brief instructions for updating filters and data. Please share a sample workbook, the desired PDF layout, and whether macros are permitted in your Windows Excel setup.
₹850 INR in 10 days
0.0
0.0

Hi, I've read your project description and it's something I can help with. I'm WillemS9, a developer who builds websites, dashboards, and business tools, and I can start right away. I specialize in Excel automation and have extensive experience with IF and SUMIF formulas. I can create a dynamic workbook that filters data, performs conditional calculations, and summarizes results clearly. Additionally, I will implement a one-click PDF export feature that maintains the integrity of your data. To give you an accurate price and timeline, could you tell me what the most important result is for you, and whether you have a deadline? Worst case, we have a quick chat and you walk away with a free consultation on your project. Regards, WillemS9
₹750 INR in 7 days
0.0
0.0

Hi, I can build a clean Excel reporting system that automatically updates as new rows are added and produces a professional PDF report with one click. I can handle: • IF, SUMIF, SUMIFS and other criteria-based formulas • Dynamic ranges/tables so formulas expand automatically • Live filtering and conditional calculations • Summary sheets based on selected criteria • Optional charts and additional reporting tables • Toggle controls to show/hide charts or sections • VBA or button-based PDF export • Defined print areas and professional page formatting • PDF output that always reflects the latest workbook values • Simple notes showing where to add data or update criteria I can keep the workbook easy to maintain, so you won’t need to edit formulas or VBA each time new data is added. I have experience with Excel formulas, dynamic reporting, VBA automation, dashboards and PDF export workflows. I’m available full-time and can start immediately. Regards, Abhishek
₹750 INR in 10 days
0.0
0.0

One macro-enabled workbook where IF/SUMIF-style formulas filter and summarise your data as new rows arrive, and one button exports the report sheets to a clean PDF. What the hours cover: - Your data turned into an Excel Table, so every formula grows with new rows without editing ranges - Criteria cells on a settings sheet that drive the IF, SUMIFS and COUNTIFS logic and the filtered views - Summary sheets rolled up by the criteria you choose - Charts or extra tables where they make the report clearer, each switched on or off by a checkbox on the settings sheet, no code to touch - A VBA button that exports the chosen sheets or print range to PDF with set page layout, so the PDF always matches the current workbook - Plain-language notes on where to change criteria and add data Desktop Excel for Windows, no add-ins. Instead of sample screenshots from past work, I can send screenshots of your workbook as it takes shape. At work I wrote and maintained Excel VBA tools for 3+ years, including reporting macros for data exported from other systems. This would be my first contract on Freelancer, and this price is for my first review here. Hourly: INR 750/hour, about 6–8 hours for the full workbook; I will tell you before going past 8. One question: which criteria do you filter by most often (for example date range, category, region)? — Suminawa
₹750 INR in 3 days
0.0
0.0

I can upgrade your Windows Excel workbook with dynamic IF/SUMIF summaries and a one-click PDF export that reflects the latest calculated results. I would use structured tables and criteria cells so new rows update the summaries, then add a VBA export button with a defined print area and switches for optional charts/tables. I would check source totals, blank/duplicate cases and changed criteria, and compare the exported PDF against the recalculated workbook. You would receive the working file and brief update instructions. My background includes finance reporting, budgeting, VBA and data migration. I represent AguliGames and use AI-assisted development and drafting with review/testing; external AI processing of client data requires your permission. Could you share an anonymised workbook showing the desired summary and PDF layout, together with your Excel version, so I can confirm the complete scope and effort? My introductory rate is INR900/hour, with a 10-hour weekly ceiling and only actual work time billed. The ceiling is not an estimate of the total job: I would agree the total effort, deadline, data handling and funded payment setup after reviewing the sample. Oto Kandelaki
₹900 INR in 10 days
0.0
0.0

Hi, I can set this up in your workbook: an Excel Table so formulas extend automatically as rows are added, IF/SUMIFS for the conditional calculations, a criteria-driven summary sheet, and a VBA button that exports the defined print range to a clean PDF, with charts switched on or off from a settings cell (no code editing needed). You also get a one-page plain-language guide on where to change criteria or add data. Built for desktop Excel for Windows. I have no portfolio screenshots on this platform yet, so I will build a small demo on dummy data within 24 h so you can see the approach before committing. Rate 1,000 INR/h, estimated 6-10 hours. Can you share a sanitised copy of the workbook? Albert (CIRAMEVA, Spain)
₹1,000 INR in 10 days
0.0
0.0

Your acceptance test is the right one, and it is exactly where most macro jobs quietly fail: the export fires before a volatile formula finishes recalculating, so the PDF shows the previous state and nobody notices for a week. How I would build it: 1. IF / SUMIF / SUMIFS logic written against structured Table references, so formulas extend themselves when rows are added. No fixed ranges to re-drag. 2. Criteria-based summaries driven by cells you edit, not values hard-coded inside the formula. Change the criterion and the roll-up follows. 3. A VBA export routine that forces a full recalculate first, sets the print range, then writes the PDF. Charts and extra tables sit on sheets the macro shows or hides from one toggle cell, so you switch them without touching code. 4. Plain-language notes: what each formula does, where to change criteria, how to add a sheet to the export. Before sending it I add rows to your data, re-export, and check the PDF totals against the sheet. You get the .xlsm with commented, readable code, not a locked project. To quote properly I need the workbook, or a sample with the same column layout. Two things worth telling me: which sheets or print range belong in the PDF, and whether the file must stay macro-free. If your Excel blocks macros I would use Power Query with native export instead, which changes the build. Chaman Raj, Purffle, Chennai.
₹750 INR in 5 days
0.0
0.0

I recently helped a client enhance their Excel workbook to automate data filtering and reporting, making their workflow significantly more efficient. I can create a fully functional Excel file that incorporates IF and SUMIF formulas to filter data dynamically, while also providing clear summaries. Your requirement for a streamlined PDF export routine is well within my expertise, ensuring that the output mirrors the latest workbook state. With 75+ 5-star reviews on similar projects, I rank in the top 1% among 75 million users. I’d love to discuss how we can make your reporting process seamless and user-friendly. Regards, HGNadia
₹750 INR in 7 days
0.0
0.0

I can build the workbook's IF/SUMIF-based summaries so new rows feed the correct criteria automatically, then add a one-click PDF export for the selected report sheets or print range. I will preserve the current calculations in the PDF, make optional charts/tables easy to toggle, and include brief instructions for changing criteria and adding data. I can start after reviewing your workbook and target a working version in three days, with final timing confirmed against its size. I will test changing input rows, recalculation, and PDF output in desktop Excel for Windows. My Freelancer profile is new; I will validate the result against your acceptance criteria rather than claim previous marketplace work.
₹1,000 INR in 10 days
0.0
0.0

Hello, I can help you build this Excel reporting workbook with reliable, maintainable formulas and a clear reporting structure. I have practical experience building Excel/Google Sheets-based business trackers, MIS reports, dashboards and management systems, including dynamic formulas, data summaries, conditional calculations and reporting workflows. For your project, I can set up the IF/SUMIF logic so calculations and summaries adapt as new data is added, with clear criteria-based reporting and a clean workbook structure. I can also configure the PDF reporting workflow so the exported report always reflects the latest workbook data, using Excel’s native export/print functionality where appropriate. I will keep the workbook easy to maintain and provide simple notes explaining where future data and criteria changes should be made. I prefer to build the solution in a straightforward way rather than adding unnecessary complexity, so the workbook remains usable after delivery. I would be happy to review your existing workbook and confirm the best approach before implementation. Thanks Sanjeev
₹1,000 INR in 20 days
0.0
0.0

Rudrapur, India
Member since Apr 15, 2024
₹400-750 INR / hour
$250-750 USD
₹3000-5000 INR / hour
$15-25 USD / hour
$30-250 USD
$250-750 USD
$1500-3000 CAD
₹750-1250 INR / hour
₹12500-37500 INR
€8-30 EUR
$30-250 USD
$250-750 USD
₹12500-37500 INR
$30-250 USD
₹750-1250 INR / hour
$10-30 AUD
₹100-400 INR / hour
₹12500-37500 INR
₹2500-3000 INR / hour
₹1500-12500 INR