
Completed
Posted
Paid on delivery
I have an XLS file ready for you; the first two worksheets outline exactly what each macro must do and every subsequent sheet already holds the sample data you will need for testing. The job is straightforward: develop two VBA macros that run flawlessly under Excel 2003, each aimed at automating the repetitive data-cleaning steps described in those instruction tabs. Because the workbook will remain in an older production environment, please keep all code compatible with VBA 6.3—no late-version references or add-ins. When the macros finish, the sheets should be left tidy, consistent and free of the issues called out in the spec (trailing spaces, stray characters, duplicated rows, and similar). Efficiency matters; the data sets grow large, so avoid screen flicker and unnecessary loops. Deliverables • Updated workbook with the two macros embedded and ready to run via clearly named buttons on the instruction sheet • A separate .bas export of each macro, fully commented, so I can import them into other files if needed • A short read-me summarising any assumptions plus the key steps you automated I will verify the code by running it on the supplied data, then on a fresh batch; acceptance is complete when the results match the expected outcome noted in the examples.
Project ID: 40416551
12 proposals
Remote project
Active 14 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

Hi Dieter, I have huge experience in Excel and VBA and will be happy to help you with the project. Regards, Eugene
$20 USD in 7 days
6.7
6.7
12 freelancers are bidding on average $19 USD for this job

I ALREADY MADE SIMILAR PROJECT LIKE THAT BEFORE. I have extensive experience developing high-speed VBA 6.3 cleaning scripts for legacy Excel 2003 environments, focusing on large-scale deduplication and formatting. I will deliver the updated XLS workbook with integrated buttons for both VBA macros, commented .bas source files, and a concise read-me detailing the automation logic. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$10 USD in 1 day
6.5
6.5

As an experienced professional with expertise in Automation, Data Analysis, and Excel Macros, I am confident that I can successfully deliver the results you require for your Excel 2003 Cleaning Macros project. My vast understanding of data cleaning paired with my mastery of Excel VBA will undoubtedly enable me to develop the macros you need to perform these repetitive tasks smoothly. I understand the importance of compatibility in older production environments, which is why I guarantee code that is fully compatible with VBA 6.3 – no late-version references or add-ins involved. I'll ensure your worksheets are left tidy, consistent, and free from any issues listed in the specification. Efficiency is another key focus for me; proficiency matters when dealing with large data sets and I am adept at minimizing screen flicker and unnecessary loops. By hiring me, you're not only getting a skilled freelancer but also someone who'll provide you with a comprehensive solution including the embedded macros in your workbook, separate .bas exports that are fully commented for portability, and a concise read-me summarizing every assumption and key automation steps. You can rest assured with my meticulous approach as I will verify the codes on both supplied data and fresh batches to make sure they produce the expected outcomes. Let's get started on making that data squeaky-clean!
$20 USD in 1 day
4.5
4.5

Hi there, I will implement two VBA macros fully compatible with Excel 2003 / VBA 6.3 to perform the exact cleaning steps described on your first two worksheets, and embed clear buttons on the instruction sheet for one-click execution. - Deliverable 1: Embed Macro A and Macro B in the workbook, each implemented using VBA 6.3-compatible code to remove trailing spaces, strip stray characters, collapse duplicated rows, trim columns, and preserve required columns exactly as your spec describes. - Deliverable 2: Provide two .bas exports (fully commented) and a short README describing assumptions and the automated steps for reuse on other files. - Risk/Quality control: backup checkpoint and post-fix validation using a staged run on the provided sample sheets to ensure results match your expected examples. Skills: ✅ Excel VBA (VBA 6.3 / Excel 2003) ✅ Excel 2003 workbook / legacy compatibility ✅ Data-cleaning automation (trimming, dedupe, character stripping) ✅ Efficient row/column processing to avoid screen flicker and slow loops Certificates: ✅ Microsoft® Certified: MCSA | MCSE | MCT ✅ cPanel® & WHM Certified CWSA-2 I’m available to start immediately. Should I attach the cleaned workbook with macros enabled (.xls) or provide a separate macro-only .xls alongside the .bas files for import? Best regards,
$30 USD in 1 day
4.0
4.0

Hello, I understand the importance of automating your data-cleaning processes in Excel 2003 to ensure your workbook remains efficient and free of clutter. My approach will involve developing two VBA macros that adhere strictly to the requirements outlined in your instruction tabs, ensuring full compatibility with VBA 6.3. Here is what I will deliver: - Updated workbook with the two macros embedded and ready to run via clearly named buttons on the instruction sheet - A separate .bas export of each macro, fully commented, so you can import them into other files if needed - Clean code that minimizes screen flicker and loops, ensuring efficient processing of large data sets I can confidently complete this within your budget and timeline, and I will keep you updated throughout the process. Could you clarify if there are any specific data formats or exceptions I should be aware of while cleaning the data? Best regards
$20 USD in 7 days
2.4
2.4

Yes! You are on the right bid. I have read all project details and descriptions regarding Two Excel 2003 Cleaning Macros I will save your time by letting my work speak for you. If I am lucky enough to get your attention, please feel free to reach me so we can spend 10-15 minutes and discuss everything ;) You can check my portfolio and reviews regarding your Project: https://www.freelancer.pk/u/Q@d33rM3hdi Best regards! Qadeer Mehdi!
$15 USD in 1 day
1.9
1.9

Two Excel 2003 cleaning Marcos? I am expart in this work. I will provide high-quality, error-free data entry services for ensuring all information is organized, formatted, and delivered according to your specific requirements. I am a Data Entry Expert. I have knowledge of Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft PowerPoint etc full of Lead Generation course.I will give 100% satisfaction work.
$10 USD in 7 days
1.0
1.0

Hi, I’m Amit Ranjan, and I can develop efficient, Excel 2003–compatible VBA macros to automate your data-cleaning tasks. Project Understanding: You have a structured workbook where the first two sheets define macro requirements, and the remaining sheets contain test data. You need two reliable VBA 6.3 macros that clean large datasets (removing duplicates, trimming spaces, fixing inconsistencies) while maintaining performance and compatibility with older Excel environments. Proposed Solution: I’ll carefully review the instruction sheets and translate each requirement into optimized VBA logic. The macros will: • Clean data (trim spaces, remove duplicates, fix formatting issues) • Handle large datasets efficiently using arrays and minimized loops • Disable screen updating and calculations during execution to improve speed • Be fully compatible with Excel 2003 (no modern dependencies) I’ll embed both macros into the workbook with clearly labeled buttons for easy execution. Additionally, I’ll provide separate, well-commented .bas files and a concise readme explaining logic and assumptions. All outputs will be tested against your sample data to ensure accuracy. Questions: Can you share the XLS file for review? Are there any edge cases not covered in the instruction sheets? Expected data size (rows/columns) for performance tuning? Should logs or error handling be included? Any naming conventions for macros/buttons? I’m ready to deliver clean, fast, and fully compatible macros.
$20 USD in 7 days
0.0
0.0

NAPLES, United States
Payment method verified
Member since Apr 22, 2012
$10-30 USD
$10-30 USD
$10-30 USD
$30-250 USD
$10-30 USD
₹1500-12500 INR
₹600-1200 INR
$80-240 HKD
₹100-400 INR / hour
$2-8 USD / hour
$250-750 USD
$10-30 USD
$15-25 USD / hour
₹600-666 INR
₹600-1500 INR
₹750-1250 INR / hour
£20-30 GBP
₹750-1250 INR / hour
$10-30 USD
₹600-1500 INR
$15-25 USD / hour
₹400-750 INR / hour
$15-25 USD / hour
₹1500-12500 INR
₹1500-12500 INR