
In Progress
Posted
Paid on delivery
I need a skilled VBA developer to help import, clean, and combine data from separate Excel files in a folder. My project is to populate YTD figures from group entities & transfer to workbook (Retrieve entity data, Transfer quarterly figures, automate forex) Key Tasks: - Automate filling in or copying data between sheets. - Handle multiple Excel files for data integration. Ideal Skills: - Proficiency in Excel and VBA. - Experience with data manipulation and automation. - Attention to detail and problem-solving skills. Looking forward to your expertise!
Project ID: 40785920
34 proposals
Remote project
Active 4 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
34 freelancers are bidding on average $37 SGD for this job

Hello, I’ve reviewed your need for a VBA solution that can pull entity data from multiple Excel files, clean and combine it, then populate YTD and quarterly figures with forex automation. Let’s chat and discuss it further To handle your project, I will start with a structured VBA macro that loops through the folder, opens each workbook, extracts the required entity data, and maps it into the target workbook. I’ll use Excel VBA, arrays, dictionaries, and optimized range handling to reduce manual work and keep the process fast, accurate, and easy to maintain. I’ll also add logic for cleaning inconsistent data, transferring quarterly values, and applying forex calculations where needed. You’ll get a fully automated Excel workflow for importing, combining, and transferring group entity data. I’ll also provide a polished macro with clear code structure, so future updates or sheet changes can be handled smoothly. Before signing-off my bid, I would like to ask a question, i.e., "Do all source files share the same sheet structure and column layout, or do they vary by entity?" If you’d like, I can outline the best VBA structure for your workbook setup. Best Regards, Aneesa.
$12 SGD in 7 days
7.2
7.2

Entity files rarely share identical layouts; the macro reads figures by header, not cell address, so a shifted row never breaks the pull. Day 1: a working macro on your sample files so you can tie it to your current manual figures. Day 2: final version with a log of which entities loaded, which were missing, and the rates applied. 1. Where do forex rates come from: a rate sheet you maintain, or should I add one you fill each quarter? 2. Are quarterly figures derived from YTD differences, or supplied as separate quarterly columns? Send one entity file and the target workbook and I can start today.
$26 SGD in 2 days
7.0
7.0

Hi, I got that you are looking for a VBA automation solution to import, clean, and combine data from multiple Excel files in a folder, then populate YTD figures from group entities, transfer quarterly figures, and automate forex updates accurately. This is what I can help you with, let's chat To handle your project, I will build a robust Excel VBA macro that loops through the folder, opens each source workbook, extracts the required entity data, cleans inconsistencies, and maps it into your target workbook with precise sheet-to-sheet transfers. I’ll use structured VBA routines with error handling and lookup logic so the process is repeatable, reduces manual copy paste, and correctly handles quarterly figures and forex conversion rules. The hardest part is reliably consolidating mixed source files into one clean output without breaking formulas or pulling wrong values, and I’ll address that directly with controlled mapping and validation checks. I’ll also refine the macro after testing with your real files. As final deliverables you will receive a fully working VBA automation macro, integrated workbook transfer logic for YTD and quarterly data, folder based multi file import and consolidation, forex automation, and a clean, easy to run solution that you can reuse on future files. One thing I’d like to confirm before we start: do all source files share the same sheet structure and column layout? Regards, Imran
$12 SGD in 1 day
5.7
5.7

I've built Excel VBA automation solutions for data integration and manipulation, so this is right in my wheelhouse. I'll automate data extraction, cleaning, and consolidation from multiple Excel files into a single workbook, ensuring accurate YTD figures and quarterly transfers. The process involves setting up data retrieval, automating data transfer between sheets, handling forex adjustments, and validating outputs for consistency. I'll ensure robust handling of various data formats to avoid issues during integration. I have questions, what specific Excel versions are you using? Another question is are there particular data sources or formats I should be aware of for the entities? Thanks, Andrii.
$36 SGD in 1 day
4.8
4.8

Expert VBA developer here I have the experience working on these type of projects which you can see on my profile, I am abuser. I have over five years of experience I am a expert in excel AI automation etc Let’s connect to discuss more about this project Thanks.
$36 SGD in 1 day
4.4
4.4

I can build a reliable VBA automation solution to consolidate group entity data, populate YTD figures, transfer quarterly results, and automate foreign exchange calculations, reducing manual effort and improving reporting accuracy. Thank you for considering my proposal. I have gone through the requirements in detail. I will develop a structured Excel VBA solution to retrieve data from multiple workbooks in a designated folder, clean and combine the information, map figures to the correct sheets, and transfer quarterly and YTD values into the target workbook. I will also automate forex-related calculations based on your specified rates and rules, with validation checks to flag missing or inconsistent data. The solution will be easy to run, maintain, and reuse for future reporting periods. I have uploaded samples of similar projects completed by me earlier in my profile. With 10+ years of experience, I bring strong expertise in advanced Excel, VBA automation, financial reporting, and data integration, with a focus on accuracy and efficiency. Payment & delivery assurance: ✅ No upfront payment ✅ Release payment after completion or milestone ✅ Regular update related to project ✅ Timely delivery ✅ 100% commitment to project completion I’m ready to turn your recurring consolidation process into a smooth, automated workflow. Could you share a sample source file and the target workbook layout?
$30 SGD in 1 day
3.7
3.7

I can build the macro that pulls YTD figures from each group entity file into your workbook and converts them at forex, so the whole update runs from one button. The part that usually breaks these is entity files that don't line up, with the same account on a different row or a different currency column, so I'd match rows by account label rather than by cell position. Our Messy spreadsheet cleaner on the profile merges Excel exports and logs every change, which is the same kind of file work. The price is 40 SGD for the whole job. I'd start by opening two entity files next to your target sheet to see where they differ, and I can take this on now.
$40 SGD in 6 days
3.4
3.4

Hi, a VBA macro that walks a folder of entity workbooks and drops their YTD and quarterly figures into your group file. Forex is where these slip, one stale rate skews every total. How we would do it: a mapping sheet linking each entity cell to its target line, a loop opening each file read only, then a rates table applied per currency before writing. Do the entity files share one layout? Excel consolidation work is routine for our team. Happy to start with one entity as a first milestone. Regards, Digitalizers
$25 SGD in 7 days
3.1
3.1

I can build a reliable VBA macro that loops through the Excel files in your folder, retrieves each group entity's YTD figures, cleans the data, and transfers the quarterly figures into your master workbook. I'll automate the forex conversion, add error checks and a log for missing or mismatched data, and keep the code clearly commented. I focus on accuracy and attention to detail, and I'll test on your real files before hand-over.
$36 SGD in 7 days
2.6
2.6

⚡ THIS LOOKS LIKE A GREAT FIT. We recently streamlined a complex data integration process using VBA for a client with similar needs. Your goal is to efficiently pull together YTD figures from various entities while ensuring accuracy and ease of use. We’ll focus on automating data transfers across sheets and ensuring seamless handling of multiple files, while also prioritizing any forex adjustments that may arise. I personally oversee all communication, coordinate the right specialists, and ensure quality checks before delivery. REACH OUT, LET'S KEEP THIS SIMPLE. Regards, Stefan Clavorn Collective
$30 SGD in 7 days
2.5
2.5

❤️ Hi there ❤️ Automating business workflows is a core part of my work, and your Excel process is a strong match for my experience building reliable systems that reduce repetitive manual tasks. I can use VBA automation to retrieve entity data from multiple files, clean and combine the information, transfer quarterly figures into the required workbook, and support automated forex calculations. My background includes developing production business systems and connecting data across CRMs, forms, and operational platforms using automation tools such as n8n, Zapier, and Make. That experience translates well to structured Excel data integration, sheet-to-sheet transfers, and handling repeatable workflows with attention to accuracy and maintainability. I would be glad to apply my automation skills to make your YTD reporting process more efficient and dependable. Choose me to build a practical Excel workflow that is easier to run and maintain. Best, Rose
$200 SGD in 1 day
0.0
0.0

your ytd figures from each group entity file can land in one workbook automatically, with the quarterly numbers and forex handled too this is vba work across several excel files and i can do it properly for you i'll stay on it, fixing any bugs that come up, until the numbers land right in your workbook where do the forex rates come from, a sheet you keep or somewhere else? send one sample entity file whenever you like, and i'm around for support after handover too Sela
$30 SGD in 3 days
0.0
0.0

Hi there, I am excited to submit my proposal for your Excel VBA Automation project. With extensive experience in Excel and VBA, I am well-equipped to assist you in importing, cleaning, and combining data from multiple Excel files. Your project requires a keen eye for detail and proficiency in data automation, both of which I possess. I understand the importance of accurately populating YTD figures from group entities and ensuring seamless data integration across workbooks. My expertise in VBA allows me to automate the data transfer process efficiently, ensuring that quarterly figures and forex adjustments are handled with precision. Having worked on similar projects, I am adept at automating data manipulation tasks, which will save both time and reduce the likelihood of errors. I will focus on creating robust scripts that can handle variations in data formats and structures, ensuring a smooth operation regardless of the input files. I am committed to delivering a solution that not only meets but exceeds your expectations. My approach will involve a thorough analysis of your existing data structure to create a tailored automation process that fits your specific needs. Thank you for considering my proposal. I am eager to bring my skills and experience to your project and look forward to the opportunity to work with you. Best Regards, Efanntyo
$12 SGD in 90 days
0.0
0.0

Hi there, I can help you build custom, robust, and error-free Excel VBA macro automations to streamline your workflows, eliminate repetitive manual tasks, and optimize data processing speed. Core VBA Capabilities Automated Data Processing: Data cleansing, extraction, parsing, dynamic formatting, and report generation. Database & API Integration: Connecting Excel with external SQL databases, RESTful APIs, JSON/CSV feeds, or Google Sheets. User-Friendly Interfaces: Custom UserForms, interactive buttons, dynamic dashboards, and automated email dispatching via Outlook. Performance Optimization: Clean, modular VBA code using dictionary objects, memory management, and structured error handling to run macros at high speed without crashing. Development Milestones Workflow & Data Schema Review: Analyzing source data structures and mapping automation rules. VBA Scripting & User Interface: Building core macros, event triggers, and control panels. Validation & Optimization: Stress-testing edge cases and accelerating execution speed. Handover & Documentation: Delivering commented code with step-by-step user instructions. Let's discuss your specific Excel sheets and requirements! Best regards,
$30 SGD in 1 day
0.0
0.0

Your YTD figures from each entity file in the folder land in the workbook, forex converted. Send me a sample entity file and I start by mapping its columns.
$66 SGD in 4 days
0.0
0.0

Excel VBA automation and data processing are the core skills I can apply to streamline your YTD reporting workflow. I can help automate the retrieval of entity data from multiple Excel files, clean and combine the required figures, and transfer quarterly values into the appropriate workbook sheets. My background as a Software Engineer with 6+ years of experience developing robust business solutions supports careful handling of data integration, automation, and recurring spreadsheet tasks. Combined with my skills in Excel VBA, data analysis, data processing, and automation, I can build a reliable solution for filling sheets, consolidating files, and automating forex-related calculations. I am ready to bring structure and efficiency to this Excel process and would be glad to deliver a practical VBA automation tailored to your reporting needs.
$30 SGD in 2 days
0.0
0.0

Hello, I understand that you require Excel VBA automation. You need to automate your routine spreadsheet tasks and process data efficiently. I will write clean macros to handle your data integration accurately. With 5+ years of experience and a 5 star rating, I am confident that I can provide you with the best solution regarding Excel VBA automation. I assure you with professional communication until your work is done. Let's connect in chat so I can understand your requirements and get started right away. Regards, Tariq
$42 SGD in 1 day
0.0
0.0

Hi there, You need entity files combined and figures with forex transferred into one workbook. Entity or period mismatches can quietly skew totals. I'd use VBA folder iteration with entity and quarter mappings, then validate forex before writing. I've built similar Excel imports, matching rows by entity code. Please clarify: 1. Do source files share a layout? 2. How are forex rates selected? I can map the transfer flow and help protect existing formulas. Hope to hear from you. Kind regards, Zohaib
$12 SGD in 2 days
0.0
0.0

Singapore, Singapore
Payment method verified
Member since Oct 25, 2026
£250-750 GBP
₹750-1250 INR / hour
₹2000-5000 INR
$30-250 USD
₹750-1250 INR / hour
$1500-3000 USD
₹10000-15000 INR
£10-15 GBP / hour
$30-250 USD
$15-25 USD / hour
$250-750 USD
₹750-1250 INR / hour
₹750-1250 INR / hour
$30-250 USD
$250-750 USD
₹12500-37500 INR
₹1500-12500 INR
₹600-1500 INR
₹12500-37500 INR
$15-25 USD / hour