MS EXCEL - VBA & Macro Development (Moderate)

€8-30 EUR

Completed

Posted 10 months ago

€8-30 EUR

Paid on delivery

As I'm launching a new business, I need your expertise in developing VBA scripts and macros in Excel to help me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD [login to view URL] • Output: [login to view URL] The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “[login to view URL]”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, on 3 fields. The macro allows to: • Generate the Output in a separate spreadsheet (which captures only the required fields and re-arrange them) • Optional: Enable the Save function (allowing to define the saving location). o Default the Saved name as: [login to view URL] (Allowing me to select the saving location). Important: The Macro must not be attached to a workbook, but needs to be attached to the set of Excel Macro. Reason: The Input file can be extracted on-demand. Skills and experience required: - Expert in MS Access VBA and Macro. - Advanced knowledge on the coding functions. - Ability to challenge or question the BRD in a constructive manner - Potentially propose functional amendment/solutions which serve the ultimate goal. - Ability to work with provided designs or suggest design recommendations - Strong communication skills to discuss additional features. - Ability to align with project lead and other developers under the project. - Access to Trello Dashboard and MS TEAMS for collaboration purposes. The following constraints needs to be considered: - Need ability to clearly understand the technical requirements as per this description - End-project documentation. This project will lead to other mission if it is achieved with success, within time, and gives satisfaction. Thanks to Bid for the project only if the mission charter falls under your technical and non-technical perimeter. Perfect Written/Oral communication in English, French or Russian is a must. Reliability: Given the importance of these automations for my new business, I need someone who can deliver on time and with quality. Please share your relevant experience, and if possible, any examples of your past work in Excel VBA automation. Thank you!

Excel

Visual Basic

Data Processing

Project ID: 37987693

About the project

29 proposals

Remote project

Active 10 mos ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@MimiFL

Hi, this is very simple and common request. I've checked all 3 files and this is pretty straightforward. If you are interested, feel free to message me and i will try to code this for you immediately. I am available right now and i would be happy to help. Thanks, Milan

€25 EUR in 1 day

5.0

(851 reviews)

7.6

29 freelancers are bidding on average €23 EUR for this job

@schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep

€50 EUR in 2 days

4.9

(607 reviews)

8.6

@vsprybhanu

Hi, I can develop Excel VBA Macro as per your requirements. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more detail. Thanks, Virendra

€30 EUR in 3 days

4.9

(145 reviews)

6.2

@mobimubasir

Hello. I read your requirement and also check attachment i will do that. Please come on chat we will discuss more about this. I will waiting your reply.

€30 EUR in 1 day

5.0

(29 reviews)

4.8

@TayyabDastgir

Hello, Kindly consider initiating a CHAT to transform your aspirations into tangible reality, as I am eager to delve into the intricacies of your project and collaborate effectively to achieve your desired outcome. Here's what I offer:  Automation (Macro/VBA)  Financial Analysis  Formulas and Functions  Data Analysis (PivotTables, Charts)  Charts and Graphs  Reports and Dashboards  Data Entry and Management  Conditional Formatting  Tables Creation  Data Validation  Collaborative Work  Data Import/Export  Filtering and Sorting  Scenario Analysis  Solver Optimization The initial bid is flexible as we aim to understand your project fully. Let's work closely for exceptional results. Best regards, Tayyab Dastgir

€30 EUR in 1 day

5.0

(22 reviews)

4.9

@saim2105

With over a decade of experience in Data Processing and Excel, I am confident that I am the Excel VBA specialist you need. My expertise lies in developing advanced macros and VBA scripts exactly like the one you require for your Input-to-Output file transformation. Having worked extensively with similar projects, I completely understand your need for a robust solution that's flexible, efficient and has excellent compatibility with different versions of Excel. By leveraging my skills, we can transform any input file into the desired output format with precise alignment to your detailed specifications. When it comes to macros, precision is key. One missed value or a misplaced column could lead to significant errors. That’s why I have learned to pore over every detail with a fine-toothed comb, ensuring high-quality output every time. Additionally, I am accustomed to working closely with project leads and other developers to align my solutions seamlessly with the broader goals of a project. I add value beyond just executing code. Throughout our collaboration, I will actively engage with you to better understand your needs and suggest ways that we can streamline and optimize your processes. Above all, my commitment is to deliver on time and exceed your expectations – because my ultimate satisfaction comes from knowing that my work empowers businesses like yours. Say goodbye to repetitiveness and let me automate these tasks for you!

€19 EUR in 1 day

4.9

(18 reviews)

4.6

@anowarbss

Hi There, developing VBA scripts and macros in Excel to help you automate several repetitive tasks, as a professional and dedicated freelancer, I understand the value of accuracy. I am confident in my ability to complete this project efficiently and effectively. I am committed to delivering high-quality results that meet your expectations. so please contact me then I am ready to start now.

€19 EUR in 1 day

5.0

(44 reviews)

4.7

@shahajalalbabu00

Hi François! As a professional and dedicated freelancer, I understand the value of accurate and efficient data entry. My expertise in Data Entry, Data Processing, and Excel will surely prove useful for this project. I have an excellent command over Power BI and can help you extract your data exactly the way you see it on the platform. In line with your goal to download the Excel file with utmost precision, I can assure you that my meticulous attention to detail will ensure a flawless transfer of all your data. Moreover, I have a strong understanding of how Power BI functions, which helps me maintain data integrity while exporting. Finally, my commitment to client satisfaction means that I will be available 24/7 for any queries or changes you might require. We'll be able to work closely together during the project, guaranteeing not only a successful transfer but also a pleasant collaboration experience. Choose me for this project and let's achieve your goal together! Thanks

€30 EUR in 1 day

5.0

(47 reviews)

4.4

@mian62

Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?

€12 EUR in 1 day

4.9

(20 reviews)

4.1

@CongJP

Hello I am a Vietnamese person with 8 years of experience in Excel, and Excel VBA especially data conversion/ analysis, and user interface. I am interested in your task and would like to apply. If possible please discuss this in more detail. Thank you.

€19 EUR in 7 days

5.0

(6 reviews)

2.9

@pcruiz

Hi, I have more than 20 years of experience in developing custom solutions for excel using excel formulas and VBA. I am capable of delivering the requirements within the given period.

€25 EUR in 7 days

4.2

(4 reviews)

1.7

@adhikarim123

Hi I have several years of full time experience in data visualization and data analytics in Excel and Power BI. I can create interactive dashboards and reports in Excel, utilizing pivot tables to summarize data and visualizations provided in Excel. I can work on extracting data from web, use formulas and functions to create calculated columns, measures as desired. I can use power query to transform/load data, use conditional formatting, data validations and power pivot for manipulating the data as required. I have extensive knowledge on Oracle, MySQL and SQL Server databases too. You need to provide me the raw data or data source and requirements, you will be provided with end results (data transformations, dashboard and visuals) as mentioned. I am Individual freelancer and can work full time or part time as required, provided I get the requirements clearly though meetings or documents. Looking forward to hear from you soon and work together.

€19 EUR in 7 days

5.0

(1 review)

0.8

@azhariqbal73

Hey François, I’m Azhar, your go-to guy for making Excel work wonders for you. I’ve spent over ten years turning complex data into clear, useful spreadsheets that help businesses run smoothly. For your project I will bring to the table: • I will create VBA script in file A. • You will put file A, your source file (file B), are your target format (file C) in the same folder • Open file A, provide a unique identifier (sku or whatever you want) from file B and press Go button • Macro will open file B, locate the unique identifier, copy all the data from that row and put that data to variables. • Open file C and put all the data from variables to the exact cells (you will nominate) • Save as the the file with specific name at specific location you desire. • That's it. Let’s talk about how I can help you with Excel. And remember, first-timers get a discount! Cheers, • Azhar

€19 EUR in 7 days

5.0

(1 review)

0.3

@Primrosetembo

Having worked extensively with MS Excel, specializing in VBA and Macros, I firmly believe I am the ideal candidate to assist you with your automation project. My technical expertise combined with a penchant for creative problem solving will ensure that I not only meet your specific requirements in a timely manner, but also potentially offer unique functionalities that enhance your business processes. My fluency in English, French and Russian is advantageous for international businesses such as yours, where effective communication is key. Furthermore, my adaptability to different work environments is demonstrated by proficiency in Trello Dashboard and MS Teams, tools crucial for productive collaboration in our project management. As someone who enjoys challenges and thrives on satisfying clients' needs through precise execution, the success of your mission will naturally lead to more projects that we can undertake together with confidence. To assure you of my capabilities, I have successfully automated numerous complex tasks using MS Excel VBA scripts and macros as outlined in your description. However, beyond technical considerations is my dedication to understanding not just the what but the why behind a task. This allows me to propose functional amendments and solutions that serve the ultimate goal rather than just following BRD blindly. My professionalism extends to end-project documentation which will be delivered orderly and efficiently

€19 EUR in 1 day

0.0

(0 reviews)

0.0

@myameengabol18

As a 10-year experienced Graphic Designer and Data Entry specialist with focused expertise in Excel, my skills are perfectly suited to deliver automated MS Excel solutions for your immediate business needs and any future projects that come along. My proficiency in MS Excel, coupled with an expert understanding of MS Access VBA and Macro, make me the ideal candidate to transform your catalog_product_option into an ImportAPO-v1.0 format. I understand the urgency and importance of this project for your business launch. My commitment to meticulousness, allocation of ample time for testing and re-testing, helps I ensure quality deliverables before deadline, even under stringent constraints like those in this project. Additionally, I’m adept at Python Scripting which makes me confident that I can provide end-project documentation akin to a proficient freelancer who knows his onions in ensuring guidelines are properly outlined.

€10 EUR in 1 day

0.0

(2 reviews)

0.0

@Alihamzaseoexp

Being an experienced and versatile freelancer, I assure you a successful completion of your MS Excel - VBA & Macro Development project. My in-depth expertise in MS Access VBA and Macro partnered with advanced coding knowledge make me more than qualified for this task. I always ensure a deep understanding of the technical requirements before proceeding with my work, which is crucial for this particular assignment. In addition to following the provided designs faithfully, I possess a unique ability to recommend functional modifications that positively impact the final outcome. This has garnered great reviews in past projects similar to yours. Furthermore, my communication skills have proven indispensable when discussing additional features during the project's execution phase. I also use Trello Dashboard and MS Teams extensively for collaboration purposes, these skills will greatly contribute to efficient teamwork. Reliability is my trademark, and timely delivery without compromising quality is my promise. I am fully dedicated to contributing towards automations that will be vital to your new business. To further assure you of my suitability, I am ready to share examples of my past work involving Excel VBA automation. As Language can create barriers in understanding requirements or denoting issues, let me tell that I'm well-versed in English, French and Russian for seamless !

€8 EUR in 1 day

0.0

(0 reviews)

0.0

@mdsabbira481

Hi there, I am ready to start right now. Please send me a message for details.100% accuracy will be delivered with a time frame and suitable budget. waiting for your reply thanks.

€19 EUR in 3 days

5.0

(1 review)

0.0

@ismail985

With my professional background in logistics and finance, I have an inherent understanding of the importance of automation and efficiency in operations. Over my extensive experience, I have developed advanced knowledge of VBA and Macros in MS Excel that I am confident will serve your business's needs to transform the input catalogue file into a specific format. What makes me stand out is my consistent ability to challenge requirements constructively, suggest innovative solutions, communicate intricately, and align well with the project's stakeholders. Being well-acquainted with collaboration tools like Trello Dashboard and MS Teams will ensure seamless communication for progress updates. Additionally, I assure you of end-project documentation, facilitating ease of usability in the long run. To further demonstrate my efficiency, I'd be pleased to share my work examples upon request. Should you choose me for this project, rest assured it would be completed on time and with utmost quality - granting your business a powerful tool to aid inventory control efficiently. Choose me for reliability and expertise; it will pave way for successful long-term collaborations.

€19 EUR in 7 days

0.0

(0 reviews)

0.0

@AliRazaAbbas

My name is Ali, and I come with an extensive background in Excel, specifically with VBA and Macro development. Over the span of my career, I've successfully automated numerous tasks similar to what your business requires, streamlining processes which saved time and increased productivity. Reading your project description, I can confidently say that the project falls well within my technical "perimeter" and matches my expertise perfectly. Understanding a client's needs thoroughly is crucial to me. To that end, I pay diligent attention to detail, questioning the brief creatively as needed, and recommend amendments/solutions beneficial to your ultimate goal. I am an Advanced Excel user with a keen eye for design, so I can effectively utilize the provided mockup and design recommendations, or suggest new ones where appropriate. Communication and collaboration are fundamental aspects of this job. I possess strong skills in both areas which allow me to work efficiently with project leads like yourself as well as other developers. Furthermore, apart from my Microsoft Access VBA and Macro proficiency, I am also familiar with using Trello Dashboard and MS Teams facilitating our smooth collaboration during the project.

€25 EUR in 5 days

0.0

(0 reviews)

0.0

@nadia60sultana

I am willing to work with you, I can import the data into Excel. You can try working with me, I will work with my best. Thank you for working with me.

€19 EUR in 7 days

0.0

(0 reviews)

0.0

@MiniMll

As a candidate for this data entry project, I believe my combination of technical knowledge, relevant experience and meticulous approach distinguishes me as the best candidate for the job. I possess a solid understanding of the tools and techniques necessary to perform data entry tasks efficiently and accurately. In addition, my organized approach and ability to effectively manage large volumes of data allow me to consistently meet deadlines and deliver high-quality results in a timely manner.

€24 EUR in 7 days