Development of Record Comparison Tool using VBA Macros
₹12000-15000 INR
Paid on delivery
Project Title: Development of Record Comparison Tool using VBA Macros
I am looking for a freelancer with advanced familiarity with VBA Macros to develop a record comparison tool. The primary purpose of the tool is to compare records across multiple datasets. There is a file attached which has the earlier version of the same macro.
Datasets:
- The client can either provide specific datasets or the freelancer can provide them, as long as the tool works as intended.
Description:
1) Find Replace component - There are two main sheets in the macro viz. Data and Report. We need to enable the user to carry out find / replace for multiple values in either of the two sheets, through a macro. Such find / replace may be subject to additional conditions based on some other fields. Also the replace field to be mentioned by the user, which can be different from the find field. Example, find security code and replace it with ISIN of underlying in the ISIN field.
Have a look at the find replace sheet in the main file.
2) Merge data from multiple sources for making the final data sheet. - There is a basic source file for making the Data sheet ready. It should ordinarily satisfy the requirement of about 70-80% fields of the Data sheet. However, for the other fields there can be different other secondary sources. They are to be ultimately merged (and not appended) to the main source file of the data. This is to be achieved using combinations of one or more fields from the primary source file. It's as good as performing a lookup (like vlookup function in Excel) and fill the data fields.
You may assume that all such secondary source files for Data sheet will be excel files. No other format like pdf, txt, json, xml will be used.
3) Display row no in the status bar - to understand whether macro is progressing and where it has reached. A status display, basically. If the macro takes a lot of time to get executed.
Please share your quote to perform this job along with the timeline. If you have any questions, we can connect on Zoom / MS Teams to discuss this further.
Skills and Experience:
- Advanced familiarity with VBA Macros is required for this project.
Project ID: #37069823
About the project
23 freelancers are bidding on average ₹14039 for this job
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 look More
Hi there, ★★★ Excel / VBA / Macros / Automation Expert ★★★ 5+ Years of Experience ★★★ I've read requirements and ready to develop a record comparison tool. I provide complete ranges of solution for your Excel, Custom More
Hi, I am a freelancer with advanced familiarity with VBA Macros. I have been working with VBA for over 10 years and have developed a variety of macros for different purposes. I am confident that I can develop the reco More
Hello there, I have checked all the details and I can build a record comparision tool by using VBA in excel. Please message me in chat so I can start right now. Regards, Ritika K
Hello there myself yesu I am a vba developer I can do this you can contact me on this for further discussion thanks
Hi, I have a few years of experience in programming VBA Macros and importing, exporting, sorting, calculating, and manipulating data in Excel, so this makes me the perfect fit for this project. I downloaded and reviewe More
Hi, I have read your requirement and check the attachment. I have noticed that I am appropriate to this project. Please open the Chat so that we may discuss this project. I am confident I can finish your project in More
I am confident that I can deliver a record comparison tool that meets your needs perfectly. With my extensive experience in advanced VBA Macros, I am well-equipped to develop a record comparison tool. I understand tha More
Dear sir/madam, We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your projec More
I'm ready to start working on your project [when] and can complete it by [when. make sure it's before the deadline the client posted].
Hii, dear. I m understand your project. I have vba macros knowledge. I m suitable for your project. I will give you my best if you give me this project.
I understand that you are looking for a freelancer with advanced familiarity with VBA Macros to develop a record comparison tool. The primary purpose of the tool is to compare records across multiple datasets. I am Th More
Dear, I hope this proposal finds you well. I understand that you're looking for an expert in Microsoft Excel to help streamline your processes, provide insights from your data, and optimize your operations. With my ext More
I will charge 15000 rupees, I will complete your project in 7 days, I will do your work well, I will provide you what you asked for.
Dear sir, I am very hard worker and honest. Rest assured that I will do your work in the best matter .Also I am a VBA Developer with extensive experience. I need extra explanations. I look forward to the opportunity to More