
Closed
Posted
Paid on delivery
I need my recurring reports to build themselves. Right now all of the source data already lives in several Excel spreadsheets; what’s missing is a robust routine—ideally driven by VBA, Power Query, or a combination of formulas and pivot tables—that pulls the data together and spits out a finished report at the press of a button. Here’s what success looks like to me: • One master workbook or template that automatically imports the latest data from the designated source sheets. • A refreshable, well-formatted summary tab that updates charts, tables, and key metrics without manual intervention. • Clear, commented code/macros so future tweaks are straightforward. • A brief hand-off note (or short screen-recording) showing exactly how to run and maintain the automation. If you have a track record of building similar Excel-based reporting systems, especially with VBA or Power Query, I’d like to get this moving quickly. More important is the implementation of formulae's so the results populate automatically when input
Project ID: 39749696
49 proposals
Remote project
Active 7 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
49 freelancers are bidding on average ₹5,792 INR for this job

With my seven years of experience as a Full-stack developer, specializing in areas such as Excel Macros and VBA and my experience in working with top companies like Metlife GOSC, DXC Technologies, and Elite Services, I am positive I can exceed your expectations for this project. My track record in designing similar Excel-based reporting systems will prove invaluable to automating your recurring reports effectively. I understand the need for a solution that not only automates updating data but also delivers well-formatted reports consistently. My expertise in utilizing VBA, Power Query and other formulas will create a master workbook that efficiently imports fresh data from designated sources and transforms them into presentation-ready reports. Clear, commented code ensures easy maintenance and future tweaks. Moreover, I firmly believe that employer satisfaction is the cornerstone of any successful project. That's why I emphasize on developing good relationships with my clients like yourself, offering not just timely completion but ensuring complete satisfaction throughout the journey. Choose me for a guarantee of dedication to quality work.
₹9,000 INR in 3 days
8.6
8.6

Hello, I can do this job. I'm working in big distribution company. We are using MS Dynamics but for reports always using Excel. I'm making reports from big data sets using VBA. Data set is about 1 500 000 line on two sheet. I think your data set will be more light, then this. Need to know more detailed about your data and job and need to see sheets I'm recommended and I will do using VBA Regarding my experience you can check in my reviews with 100% feedback I have 16+ year experience of Excel, Excel VBA and Have 100% feedback So, you can trust me result will be as you need Best Regard
₹12,500 INR in 7 days
5.9
5.9

As an Excel Report Automation Specialist with over 8 years of experience, I understand the importance of streamlining data workflows and turning data into actionable insights. I excel in utilizing key tools such as Microsoft Excel, Excel VBA, Power Query and advanced formulas to automate processes and create custom solutions. In fact, designing intricate Excel-based reporting systems featuring the requirements listed in your project description have been a core strength of mine for years. I have significant expertise in all the areas you are seeking - whether it's automating data-related tasks using VBA or Power Query, creating well-formatted, refreshable summaries or providing detailed hand-off notes on how to maintain automations - my proven track record has got you covered. Moreover, my prior work has often necessitated skillfully implementing formulas that result in automatic data population - a requirement you've specifically highlighted in your project. With my familiarity and proficiency with dynamic reporting, data modelling, VBA automation and more; I am convinced I can deliver work that meets and exceeds your expectations, while setting you up for easy maintenance in the future.
₹7,000 INR in 3 days
4.9
4.9

With 8 years of experience in data automation and reporting, I am the best fit to complete this requirement. I have the relevant skills to create a robust routine for your recurring reports using VBA, Power Query, and Excel formulas. How I will be completing this project: - Develop a master workbook or template to import data from multiple Excel spreadsheets - Create a refreshable summary tab with updated charts, tables, and metrics - Write clear, commented code/macros for easy future modifications - Provide a hand-off note or screen-recording for running and maintaining the automation What tech stack I will be following: - Excel VBA - Power Query - Excel Formulas Having worked on similar Excel-based reporting systems in the past, I understand the importance of automating data imports and populating results automatically. I will ensure that your reports build themselves with minimal manual intervention, meeting your success criteria. Let's get started on this project quickly and achieve your goal of effortless report generation.
₹1,500 INR in 7 days
4.7
4.7

With a skillset spanning across extensive data manipulation, programming languages, and database management systems, I am well-poised to tackle your automation needs within Excel. I have 7+ years of experience in full-stack development that encompasses tools like Angular, NodeJS, Java, PHP and more. My proficiency in technologies such as VBA, Power Query and formulas makes me a solid candidate for this role where you are looking to automate the generation of reports and populate results automatically. Having dabbled in various domains such as Machine Learning and Computer Vision, my approach towards projects is combining my analytical thinking with an eye for detail. This will ensure that not only will I build an automation system for your recurring reports that imports the latest data and updates charts seamlessly but also provide you with well-structured code and macros for any future modifications or enhancements. On top of it, my clear communication skills will be beneficial when preparing the hand-off document or a screen-recording to help you run and maintain the automation independently.
₹7,000 INR in 7 days
4.7
4.7

I can help you streamline your recurring reports by building a fully automated Excel reporting system using a mix of VBA, Power Query, and smart formulas. The goal is a single master workbook that imports, processes, and presents your data at the press of a button—removing all repetitive manual work. 1️⃣ Master Workbook Setup – Centralized file that pulls data from all your source spreadsheets automatically. 2️⃣ Automation & Formulas – Use of Power Query and formulas to ensure all results populate instantly when new data is added. 3️⃣ Dynamic Reporting – Refreshable summary tab with clean tables, pivot charts, and key metrics formatted for clarity. 4️⃣ Documentation & Handoff – Well-commented code/macros plus a short guide or screen recording so you can easily run and maintain the system. Best regards, Huzaifa
₹5,000 INR in 4 days
3.9
3.9

Hi , I have read your instructions and I can do it efficiently. Give me this project and get 100% extra ordinary work. Message me for further discussion. Thank you. SYEDA NIMRA
₹7,000 INR in 7 days
4.0
4.0

Hi There, As an Excel and VBA Developer, I can help you to automate your Excel report with help of VBA and I can do this easily. I have worked this type of similar projects and I have more than 3 years experinced in this profile. If you are interested so we can discuss on it. Thanks, Daksh Mahaur Excel and VBA Developer
₹12,500 INR in 1 day
4.3
4.3

I can build you a master Excel workbook that automatically pulls data from your existing source sheets, refreshes it, and generates a clean, ready-to-use summary report with charts, pivots, and key metrics—all at the press of a button. Using a mix of Power Query, advanced formulas, and VBA where needed, the system will be fully automated, with no manual copy-paste. The code and queries will be clearly commented for easy future edits, and I’ll provide a short handoff note or recording so your team can run and maintain it confidently. This will ensure your recurring reports build themselves reliably and consistently every time.
₹1,500 INR in 1 day
3.3
3.3

Hello, I’m Sartaj, my advanced Excel skills of layouts, formulas, conditional formatting, pivot tables, macros, VBA, charts combined with my talents in UI/UX design make me the perfect fit for this project. While most people associate Excel with clunky and dull reports, it doesn't have to be that way. I have a knack for turning typical spreadsheets into visually-appealing that not only provide a great user experience but also precisely communicate complex sales data with clarity. I can create a master workbook or template that automatically collects your data and prepares a ready report. My plan for you: • Build one main Excel file that links/imports data from your source spreadsheets. • Use VBA, Power Query, formulas, and pivot tables so that everything refreshes with one click. • Create a summary tab with clear tables, charts, and metrics that update automatically. • Write clean, commented formulas or macros so you can easily edit in the future. • Provide a short guide (or quick video) showing how to run the process. I have experience making Excel automation and reporting systems. I will make sure the formulas work properly so that results are updated automatically when new data is entered. I would be happy to start quickly and deliver a smooth solution for you. Best regards,
₹5,000 INR in 5 days
3.0
3.0

Hello, I understand your need for recurring reports to build themselves automatically and I can help you create a master Excel solution that delivers exactly that. My Approach: • Build a master workbook that imports and consolidates data from your existing spreadsheets. • Use Power Query, VBA macros, and advanced formulas to automate data refresh and populate results automatically. • Create a refreshable, well-formatted summary tab with charts, pivot tables, and key metrics updating at the press of a button. • Ensure the solution is easy to maintain, with clear formulas, commented code, and a short guide or screen recording for smooth handover. Why Me: • Strong expertise in Excel automation, VBA, and Power Query. • Proven track record of building robust, user-friendly reporting systems. • Focus on accuracy, efficiency, and scalability, ensuring reports stay reliable as data grows. I’m confident I can deliver a clean, professional system that saves you time and eliminates repetitive manual work. Let’s get this automation moving quickly.
₹5,000 INR in 7 days
3.0
3.0

1) Pay only if you are satisfied with the work 2) Expert in Power BI, Excel, VBA Macro, Google sheet and Google Appscript 3) 3 American MNC experience 4) Expert in Data analytics, Data Automation and visualization 5) Expert in Statistical analysis 6) Long term support 7) Quick delivery with multiple iterations
₹7,000 INR in 7 days
1.7
1.7

Hi I have extensive experience of 10 yoe of working on Excel. I use AI features in AI to bring down the effort and make it cost effective for my clients. I can create this tool in 3-5 days. Please let me know if we can discuss further. Thanks Aseem
₹1,500 INR in 5 days
1.8
1.8

I am looking for a golden opportunity to work with you, your job is relevant to my skill as I have great knowledge in data analysts and I can see you need expert for your data ,you want transform your raw data into actionable insight, I can full fill your requirement and deliver you a perfect fit for your data, please reply me and lets discuss and start the work.
₹3,000 INR in 2 days
1.1
1.1

Hey, this looks interesting and right up my alley. I’ve done similar work before and can help you get this done quickly and properly. I can implement robust routines with VBA, Power Query, and advanced formulas to automate your recurring reports. Success for you would be a master workbook that imports and updates data seamlessly, with clear commented code/macros for easy maintenance. Let's collaborate on this and I’ll deliver a well-formatted, automated solution with a smooth hand-off process. Can't wait to dive in and make this a reality. Best Regards CJ & TEAM
₹7,500 INR in 30 days
0.0
0.0

"This is my favourite kind of project to dive into. I bring clear strategy and creativity to every project, delivering results that align with the client’s goals and vision. Success here means creating a master workbook that automatically imports and updates data, along with a refreshable summary tab. I excel at VBA, Power Query, and formula automation, ensuring easy future maintenance. I’ve handled projects like this before with great results. I’m ready to dive into your project whenever you're ready to talk. Regards, Shanette"
₹8,150 INR in 14 days
0.0
0.0

Hello sbmowais, I am excited about the opportunity to automate your recurring reports using Excel. With my expertise in Visual Basic, Excel Macros, and Data Analysis, I can create a master workbook that imports the latest data and updates summary tabs with charts and key metrics effortlessly. My experience in implementing formulae and developing Excel-based reporting systems aligns perfectly with your project requirements. I am committed to providing clear, commented code for easy maintenance and a detailed hand-off note for seamless operation. I am eager to discuss how we can collaborate to streamline your reporting process and achieve your desired automation goals. Let's connect to further explore this project together. Looking forward to your response, anilptk
₹8,750 INR in 3 days
0.0
0.0

Hello, I saw your project and I am confident that I can complete it with 100% accuracy and within the given deadline. I have strong knowledge of Microsoft Excel (Formulas, Pivot Tables, Data Cleaning, Data Entry, Formatting, Charts, VLOOKUP, HLOOKUP, Conditional Formatting) and I have worked on multiple academic as well as practical projects during my BCA studies.
₹7,000 INR in 5 days
0.0
0.0

I am good at Excel and I will apply all my knowledge to complete this project effectively and efficiently.
₹7,000 INR in 15 days
0.0
0.0

Skilled in Excel automation - VBA, Pivot, Power Query to deliver smart, Self-updating smooth reports.
₹1,500 INR in 7 days
0.0
0.0

Mumbai, India
Payment method verified
Member since Nov 14, 2023
₹1500-12500 INR
₹1500-12500 INR
$30-250 USD
₹7500-15000 INR
₹5000-10000 INR
$30-250 USD
₹12500-37500 INR
₹600-1500 INR
₹1500-12500 INR
₹750-1250 INR / hour
$250-750 CAD
$30-250 AUD
$25-50 USD / hour
₹600-1500 INR
₹1500-12500 INR
₹600-1500 INR
₹750-1250 INR / hour
€30-250 EUR
₹750-1250 INR / hour
$2-8 USD / hour
₹600-1500 INR
₹12500-37500 INR
$80-240 HKD
₹1500-12500 INR
$15-25 USD / hour