
Closed
Posted
Paid on delivery
I need a single, easy-to-refresh Excel workbook that pulls price data from several separate spreadsheets I will provide. Each source file uses its own column order and naming, so the first step is to map and normalise those structures before anything is compared. Once the data is aligned, the workbook should generate a clear comparative statement that lets me see, at a glance, how each item’s price differs across the files. You are free to use native formulas, Power Query, or VBA—whatever keeps the process transparent and simple for me to maintain after hand-over. I do not need an elaborate interface; accuracy, clarity, and an uncomplicated refresh method are what matter most. Deliverables: • Master workbook with automated import/refresh routine • Normalised data table that handles the differing file structures • Comparative statement sheet showing side-by-side prices from every file • Brief instructions so I can add new source files or change folder paths later Feel free to suggest the cleanest approach and any minor enhancements that improve usability without adding unnecessary complexity.
Project ID: 40401141
16 proposals
Remote project
Active 15 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
16 freelancers are bidding on average ₹1,734 INR for this job

I understand the importance of data normalization and analysis in this project. Having solid skills in Data Analysis, Data Processing, Excel, Excel Macros, and Excel VBA, I am confident in creating a single, easy-to-refresh Excel workbook for you. My approach will prioritize accuracy, clarity, and an uncomplicated refresh method so you can easily maintain the workbook yourself. I have ample experience mapping and normalizing data with different structures into a unified format for comparison. This skill will be crucial in handling your varied source files efficiently. Moreover, my command over Power Query and VBA can further streamline the process for you. I am ready to deliver a master workbook with an automated import/refresh routine alongside normalised data tables that can handle differing file structures flawlessly. In addition to this, I believe in providing an enhanced-users experience through my works. Hence, I plan on suggesting any minor enhancements that can improve usability without adding unnecessary complexity to the workbook. You can also count on me for thorough instructions on adding new source files or changing folder paths for future convenience. Choose me for a fast, accurate, and top-quality service--your satisfaction is guaranteed!
₹5,050 INR in 1 day
4.5
4.5

Hi I have 15+ years of experience in business intelligence , excel BI and power BI. I’d be happy to help create a clean, easy-to-refresh Excel workbook that consolidates and compares pricing data from your multiple source files. I have strong experience in Excel, Power Query, formulas, and VBA automation, and can build a transparent solution that normalizes different column structures into a single master table with a clear side-by-side comparative price statement. My focus will be on accuracy, simplicity, and an easy refresh process so you can maintain it confidently after handover. The final workbook will include refresh automation and clear instructions for adding new files or updating folder paths. Ready to start immediately. Thanks Shivani
₹3,000 INR in 7 days
4.7
4.7

Leveraging my extensive expertise in data processing, including Excel skills such as macros, VBA (Visual Basic for Applications), and more, I am well equipped to deliver a robust solution for your price comparison project. I understand your need for seamless integration of different file structures and assure you of comprehensive alignment and consolidation of all data sources. My approach will not only ensure the master workbook efficiently imports and updates data from various files but will also equip it with a simplified method that you can maintain effortlessly after the hand-over. Moreover, being a full-stack developer with vast experience in API integration offers an advantage in ensuring the normalised data table accurately handles differing file structures. My proficiency will contribute to the creation of a clear and concise comparative statement sheet which aligns side-by-side prices from every file. Finally, my promise extends beyond just delivering what is expected; I always strive to provide value-added suggestions to improve usability without complicating things unnecessarily. So, not only will you receive a comprehensive solution with well-commented codes, but also step-by-step instructions empowering you to easily add new source files or change folder paths later on. Let's collaborate and ensure your project is executed efficiently while adding significant value to your business.
₹1,050 INR in 2 days
3.1
3.1

@SahyadriTech #SahyadriTech Completed Projects: 1. Hotel Booking Management & Tracking System (Excel + VBA Script) 2. Appsheet: ERP system for textile business 3. MNGL Gas Incident Tracker & Dashboard (Google Sheets + Google Data Studio) 4. Daily Expenses Tracker (Google Sheets) 5. Option Scalping Strategy Automation (Excel VBA) 6. Nifty50 Live Option Chain Dashboard (Google Sheets) 7. Binary Trading Sheet (Google Sheets) 8. Customer Data Cleaning & Sorting Tool (Excel VBA & Python) 9. Historical Stock Closing Price Analysis for 2,600 Stocks (Excel & Python) 10. Power Bi dashboard for F1 Car racing insights 11. GOLD Loan tracking in Google sheet and Google Data studio 12. Local Taxi Tracking System (Google Sheets + Google Data Studio) 13. Appsheet Milk Drivers wages and attendance system (Appsheet + Google sheet ) Key Highlights: 1. Pay only if satisfied with the work 2. Expert in Power BI, Excel, VBA Macros, Google Sheets, Google Apps Script, and Python 3. Experience in 3 American MNCs 4. Skilled in Data Analytics, Automation, and Visualization 5. Proficient in Statistical Analysis 6. Offer Long-Term Support for all projects 7. Quick Delivery with multiple revisions I can deliver any project related to Data Analytics, Automation, and Reporting with precision and reliability.
₹1,050 INR in 7 days
2.8
2.8

Hi, I can create a clean, easy-to-refresh Excel workbook that consolidates your multiple price files into one accurate and easy-to-use comparison. I’ll first map and normalize each source file, even if they use different column names or structures, so all data aligns into a single consistent table. Then I’ll build a clear comparative sheet that shows item-by-item price differences across all files at a glance. For simplicity and reliability, I recommend using Power Query for automated import and transformation. This enables a one-click refresh and makes it easy for you to add new files or update paths without technical complexity. What you’ll receive: Master workbook with automated refresh Normalized data table handling all file variations Clear side-by-side price comparison sheet Simple instructions for future updates My focus is accuracy, clarity, and long-term usability—no unnecessary complexity. I can also include small enhancements like variance highlighting if helpful. Happy to review a sample file and suggest the best structure. Best regards, Muzammal Pasha
₹1,000 INR in 7 days
2.6
2.6

Subject: Automated Price Comparison Engine via Power Query & VBA "Hi there, I can deliver a clean, robust, and easy-to-refresh Price Comparison Workbook for you. Given your requirement for handling different column structures and naming conventions, I recommend using Power Query combined with a small VBA macro for a 'One-Click Refresh' experience. How I will solve this: Normalization: I will create a mapping schema that automatically aligns different source file formats into a single master table. Comparison Logic: A side-by-side comparative statement that highlights price variances instantly. Scalability: You just need to drop new files into a folder, and the master sheet will pick them up automatically. Why Choose Me? Speed: I can have the first draft ready for your review within the next 3-4 hours. Simplicity: I will provide a simple 'How-to' PDF so you can manage it easily after handover. Accuracy: Coming from a data analysis background, I ensure zero errors in price mapping. I am ready to start immediately. Let's get your price data organized!
₹1,200 INR in 1 day
2.2
2.2

Hello! I am a Data Analyst specializing in building automated Excel workflows and data normalization routines. I have a proven record of managing datasets up to 50,000+ records with 99%+ accuracy, ensuring that complex price comparisons are both precise and easy to interpret. I recommend using a Power Query-based approach, which will allow you to import and align differing file structures automatically by simply updating a folder path. My expertise in advanced Excel functions and data modeling ensures that your comparative statement will be clear, scalable, and resilient to changes in source formatting. I prioritize clean, transparent logic so you can maintain the workbook independently after handover. I will provide step-by-step instructions for adding new files and adjusting parameters. I am ready to start immediately and can deliver an automated first draft within 24–48 hours.
₹1,000 INR in 4 days
2.0
2.0

Hi, I am Syed Taha Hussain, and I would love to build this price comparison and data normalisation tool for you. Power Query automation, data mapping, and financial reporting are my primary skills. I have extensive experience in the banking sector managing complex account reconciliations where I regularly consolidate and align data from multiple inconsistent sources. I am an expert in using Power Query to build robust normalisation engines that map differing column orders and naming conventions into a single, unified structure. I will design your master workbook so that clicking refresh automatically pulls data from your source files and generates a side-by-side comparative statement. I have several automated data consolidation projects in my portfolio. You can message me to discuss the specifics and get started.
₹1,500 INR in 3 days
1.1
1.1

Hi There, I can deliver a robust, automated Excel solution tailored for your price comparison needs. With a 15+ years in data analysis, I specialize in building "Reference Databases" that unify inconsistent data sources into clear, actionable insights. My Proposed Solution: I will use Power Query (built-in to Excel) to create your master workbook. This is the cleanest approach because it: Normalizes Automatically: Maps varying column names and structures into a single format without manual intervention. Refreshes with One Click: You simply click "Refresh All" to pull in new data from your source folders. Ensures Accuracy: Eliminates human error inherent in manual copying or complex VBA macros. Deliverables: Master Workbook: Featuring a dynamic "Comparative Statement" sheet for side-by-side price analysis. Standardized Table: A clean, consolidated view of all normalized data. Setup Guide: Simple instructions on how to update file paths or add new suppliers. Let's contact to discuss detailes. Solution Vector Roman Khakhula
₹1,500 INR in 1 day
0.8
0.8

Hello Sir/Madam, I’m interested in your data entry project. I can provide accurate and fast data entry with proper attention to detail. I am comfortable with Excel, typing, and handling large amounts of data without errors. I may be new, but I am dedicated, quick to learn, and will complete your work on time. I can also do a small sample work if needed to show my accuracy. Looking forward to working with you. Thank you.
₹600 INR in 7 days
0.0
0.0

I understand your needs clearly: a single, easy‑to‑refresh master workbook that normalises pricing data from multiple source files with varying column structures, then presents a clear, side‑by‑side comparative statement. You value accuracy, clarity, and simplicity of maintenance above all – no elaborate interfaces, just a reliable tool you can trust and adjust later with minimal effort. I can deliver exactly that. My Technical Competence I have extensive hands‑on experience building Excel‑based data consolidation systems exactly like this. My toolkit includes: Power Query (Get & Transform) – I use it daily to combine, normalise, and append files from folders, handle dynamic column mappings, and create refreshable data models. Advanced Excel formulas – including dynamic arrays, XLOOKUP, INDIRECT for flexible references, and conditional formatting for instant visual comparisons. VBA – when needed for automation (e.g., one‑click refresh buttons, folder selection dialogs). I know when to use it and when to avoid it. Data modelling & PivotTables – to produce clean, side‑by‑side comparative statements that automatically adapt when new source files appear. I also have a strong sense of transparent design – every step I build will be documented, and the final workbook will include plain‑language instructions that let you change folder paths, add new source files, or map new column names yourself, without ever touching code.
₹1,500 INR in 7 days
0.0
0.0

Hi, I can build a clean, easy-to-refresh Excel workbook that compares prices across multiple spreadsheets, even when each file has different column names and structures. My recommended approach is Power Query, as it keeps everything transparent, accurate, and simple for future maintenance without unnecessary complexity. What I will deliver: • Master workbook with one-click refresh/import • Normalized data table from all source files • Comparative statement sheet with side-by-side price comparison • Clear instructions to add files or update folder paths later I focus on accuracy, clarity, and practical Excel solutions. I can start immediately and deliver quickly. Looking forward to working with you. Best regards, Amalia
₹1,200 INR in 8 days
0.0
0.0

I can create a single Excel master workbook that automatically imports price data from all the separate spreadsheets you provide, even if each file uses different column names or layouts. I will normalise and align all fields into one clean table so every item is matched correctly. The workbook will also include a simple comparative statement that shows each product’s prices side-by-side across all files, making differences easy to review at a glance. Refreshing the data will be straightforward—either through Power Query, formulas, or light VBA—so you can update everything with one click.
₹1,050 INR in 1 day
0.0
0.0

Having worked extensively with Excel for many years, my familiarity with macros and VBA programming has equipped me to tackle this project with ease. Initially, I will streamline your data by mapping and normalising the differing structures across your spreadsheets. The final deliverable will be a master workbook, an automated import/refresh process, a normalised data table and a comparative statement sheet that presents clear insights regarding disparities in item pricing. Moreover, I believe in empowering my clients; ensuring you have the tools and knowledge to maintain the system post-handover is important to me. As such, I will provide you with detailed instructions on how to work with your new Excel system with ease. I can confidently say this project aligns perfectly with my skills and expertise. My focus on accuracy combined with my penchant for simplifying complex processes will undoubtedly add value to your workflow. To conclude, choose me not only for my skills, experience and dedication but also for my commitment to customer satisfaction. I am here to ensure the project is completed beyond your expectations, giving you an effective solution that you can count on every time you need concise price comparisons from multiple files. I look forward to the possibility of working together!
₹1,050 INR in 7 days
0.0
0.0

I am Divya, an experienced Finance and Accounts professional who is proficient in the use of MS Excel. Handling large volumes of data, including reconciliations and financial reporting, has made me an expert at ensuring accuracy and maintaining confidentiality – two crucial aspects for the project at hand. My proficiency with Excel also extends to its powerful features such as Power Query and VBA. I will provide you with a comprehensive master workbook that automates the import/refresh routine and a clearly presented comparative statement - all in line with your desire for simplicity and ease of use. In addition to my technical abilities, choosing me for this project guarantees that you will receive high-quality work on time. My professional approach and commitment to client satisfaction emphasize clear communication – which is vital for a successful project completion. I am confident that I possess the skills required to handle this task diligently while providing uncompromised accuracy. It would be my pleasure to assist you in this Excel Price Comparison Statement project.
₹1,500 INR in 4 days
0.0
0.0

Satānā, India
Member since Sep 3, 2024
₹12500-37500 INR
₹600-1500 INR
₹600-1500 INR
₹600-650 INR
₹100-400 INR / hour
₹12500-37500 INR
$10-30 USD
$8-15 USD / hour
₹12500-37500 INR
₹1500-12500 INR
₹600-1500 INR
₹750-1250 INR / hour
₹600-1500 INR
$30-250 USD
€250-750 EUR
$10-30 USD
₹600-1200 INR
₹400-750 INR / hour
$80-240 HKD
₹100-400 INR / hour
₹600-601 INR
₹100-400 INR / hour
₹600-1500 INR
₹1500-12500 INR