Find Jobs
Hire Freelancers

Excel macro project

$30-250 USD

Zamknięte
Opublikowano ponad 3 lata temu

$30-250 USD

Płatne przy odbiorze
Hello, I am trying to compare columns on three different tabs. The three columns (each on a different tab) could contain similarly named items, so I need your macro to consider near matches. You could even add a column to show the accuracy %. Once a match is identified, display like what is shown on the Desired Output tab. I want this to be modular where I can edit which tabs and columns are shown on the output tab: *// Example of how I can change the output columns in the macro: If there is an approximate match for the Account columns on any of the tabs, display: - Tab 1 Account Name - Tab 2 Account Name - Tab 3 Account Name - ["Group 1","Account"] - ["Group 1", "Month"] - ["Group 2, "Month"] -["Group 3, "Example Column name"] etc (Whatever I want to enter) Job requirements: - I would like this deliverable to work in Excel Office 365 ProPlus - It needs to handle tabs with as much as 100,000 rows each - Please be sure to start the message in your bid with the words "Dear Douglas" so that I know you have read directions carefully - Please end your bid in the number one. For example, instead of bidding ten dollars, bid eleven instead. This will further prove to me that you can read and understand directions carefully Let me know if you have any questions!
Identyfikator projektu: 26859216

Informację o projekcie

37 ofert
Zdalny projekt
Aktywny 4 lata temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
37 freelancerzy składają oferty o średniej wysokości $118 USD dla tej pracy
Awatar Użytkownika
Hi, Greetings! ✅checked your project details: Excel macro project ✅Completed Time: In project deadline We have worked on 600 + 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 Digital screencast
$220 USD w 4 dni
4,9 (421 opinii)
8,3
8,3
Awatar Użytkownika
Hi,I am an Excel Expert with Professional experience working with Excel. I have more than 10 year experince with excel. Complete a lot of jobs on Freelancer with highly satisfaction of client. I believe I can do a great work for you and ensure your quality.
$99 USD w 1 dzień
4,9 (439 opinii)
7,9
7,9
Awatar Użytkownika
Hello, as an excel developer with strong knowledge in macros, I can help you to achieve the required functionality.
$250 USD w 3 dni
5,0 (101 opinii)
7,5
7,5
Awatar Użytkownika
Dear Douglas, Greetings! I have reviewed the attachment and I can develop a macro to compare data in Group 1, 2 and 3 tabs and produce output as in "Desired Output" tab. Also, to make the output columns dynamic, I can provide a configuration table where you can map the Output columns (example columns below) to columns in each of the Group tabs. ["Group 1","Account"] - ["Group 1", "Month"] - ["Group 2, "Month"] -["Group 3, "Example Column name"] etc (Whatever I want to enter) Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 20 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 200 HOURS on automation in Excel every month. Have a Great Weekend! Srinivasan Krishnamoorthi
$91 USD w 2 dni
5,0 (230 opinii)
7,1
7,1
Awatar Użytkownika
Dear Douglas, Its better to use other technology then Excel for your requirements especially you have over 300,000 rows to compare across three sheets for fuzzy matches. Comparing approx data in Excel is not builtin support and VBA will be very slow when comparing large data. Its better to use python or other powerful language like .Net for this task. We can discuss in more details if you are interested. Thanks
$171 USD w 3 dni
4,9 (292 opinii)
6,9
6,9
Awatar Użytkownika
Hi I have recently done same job in which it compares the name and give percentage to you.I can also build you same kind of macro that can show the similarity in percentage.
$150 USD w 1 dzień
4,8 (113 opinii)
6,9
6,9
Awatar Użytkownika
---------------I CAN START RIGHT AWAY 100% ACCURACY-------------------------------- Hello sir, I have read your project details and attachment. . I can complete your project by maintaining 100% accuracy of your data absolutely as you want. -------VBA Macro Coding, Formula Generation and Automation process expert with 5* ratting. I can start right now, please message me to discuss more. Regards, MA Hossain
$89 USD w 1 dzień
5,0 (277 opinii)
6,4
6,4
Awatar Użytkownika
Dear Douglas I am Swarnali, available online more than 16 hours everyday. I have read your project details. I have completed several projects based on the excel formula, google sheet script and excel VBA macro (see in portfolio). Recently, I have deleted duplicate recored based on another sheet name that almost similar your projects. I can start now. Therefore, I would like to discuss with you about the project details. Looking forward to hearing from you! Thanks in advance. Best Regards, Swarnali
$91 USD w 3 dni
5,0 (32 opinii)
5,5
5,5
Awatar Użytkownika
Dear Douglas Gone through your requirements and yest it can be done and willing to take up this project. I am a Microsoft Certified Professional in Excel and VBA as an Expert Awaiting your response to get started immediately. Regards, Karthick G.
$101 USD w 7 dni
5,0 (44 opinii)
5,3
5,3
Awatar Użytkownika
Hi I am VBA Developer Experianced In Web Scrapping & VBA Macros I can finish this task in a day only please share the details thanks
$65 USD w 1 dzień
4,9 (50 opinii)
5,1
5,1
Awatar Użytkownika
Dear Douglas, I have gone through with contents and attached files to understand the requirements. I am interested to do this work and break your huddle. Please allow me to do this job. I am available to support you 24*7 just ping me once. I have a good knowledge of Excel, Advance Excel functions and VBA. I know Sumifs, Countifs, Averageifs, Index, Match, Vlookup, Hlookup, Sorting, Pivot table, Slicers, Developer functions & Conditional formatting, etc. Please check my portfolio to know more 150+1=151 Thanks, Jitender Kumar
$150 USD w 2 dni
5,0 (24 opinii)
4,7
4,7
Awatar Użytkownika
Dear Douglas, pls consider my bid as 150USD. its altered to show as 151 as you confirm my interest based on bidding number ending by 1 only . Next, I have 13 years experience in excel and excel VBA. my last two project reviews are some of the feedback given by my last project owner... I am sure you will be impressed with my performance
$151 USD w 2 dni
5,0 (28 opinii)
4,7
4,7
Awatar Użytkownika
⭐⭐Hello⭐⭐ Are you going to find an expert to finish your work? You are in the right place. I have strong VBA skills and it's the best solution to satisfy your requirement. I have ever made VBA DB management, Dashboard creating, Integrate APIs to get data from website or scrapping website, and save data in spreadsheets, building charts... VBA is more strong than Macro, It also uses all functionality of VisualBasic, So I can do it perfectly with VBA. I have finished many automation Excel works using VBA, My English is very conversational and I can fully ensure your requirement. Please contact me and let me work for you now. Thanks for reading. Regards.
$150 USD w 7 dni
5,0 (2 opinii)
3,8
3,8
Awatar Użytkownika
Hope you are doing great. I can help you in this project. Please send me a message to discuss more. I am available to start working on the project immediately
$70 USD w 7 dni
4,0 (7 opinii)
4,0
4,0
Awatar Użytkownika
"Dear Douglas" Hello Hope you are having a great day. I have read your requirement and I understand that you need an expert in MS Excel and VBA. Let me assure you that I have Enough Experience in this field. I am a IT professional with 3+ years of Experience with knowledge in VBA, MS Office Products Shopify, Wordpress, Website Development, Programming etc. I am capable of Delivering your project in a Timely Manner. Kindly Message me to discuss further requirements. Hope we can have a great Collaboration.
$151 USD w 3 dni
5,0 (6 opinii)
2,5
2,5
Awatar Użytkownika
Hello sir, I would like to help you on this matter. I have experience and if you like to cooperate with me message me Best Regards
$140 USD w 7 dni
5,0 (1 opinia)
1,2
1,2
Awatar Użytkownika
I will take your project with full dedication and hard work ? and I am quite good in digital marketing.
$139 USD w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hi sir, I am alteryx champion. I can perform this with the help of alteryx with less time. I have an experience of 5 years in data processing. Please work with me once you will surely like it. Thanks, Sumit
$60 USD w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Dear Douglas, I have 4 years of experience in macros and other Excel functions. i can easily make your document automated as per your requirement. Regards, Ankit
$61 USD w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Cheap labour Cheap labour Cheap labour Cheap labour Cheap labour Cheap labour Cheap labour Cheap labour
$30 USD w 7 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga UNITED STATES
Timonium, United States
5,0
97
Zweryfikowana metoda płatności
Członek od lis 7, 2010

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.