Lukket

Excel macro project

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!

Evner: Excel, Visual Basic, Visual Basic for Apps, Excel Macros, Excel VBA

Se mere: excel vba project examples, excel macro examples download, useful excel macros for accountants, excel vba projects for practice, vba automation projects, useful excel macros examples, excel macro tutorial pdf, cool vba projects, excel macro project daten importieren, excel macro protect project, run excel macro open office calc, excel macro read microsoft project, export excel data project using macro, excel macro import project files, open office calc excel macro, excel macro call project, project excel macro, export project excel macro, project excel macro libro, excel macro project 2010

Om arbejdsgiveren:
( 93 bedømmelser ) Timonium, United States

Projekt ID: #26859216

42 freelancere byder i gennemsnit $123 på dette job

schoudhary1553

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 lo Flere

$220 USD in 4 dage
(381 bedømmelser)
8.1
P0L

(416 bedømmelser)
7.7
datakillers

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 grea Flere

$99 USD på 1 dag
(304 bedømmelser)
7.5
ksriniravi

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 ca Flere

$91 USD in 2 dage
(229 bedømmelser)
7.0
tiaratechies

Hello, as an excel developer with strong knowledge in macros, I can help you to achieve the required functionality.

$250 USD in 3 dage
(59 bedømmelser)
7.0
mrbrave

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 Flere

$171 USD in 3 dage
(283 bedømmelser)
6.8
(61 bedømmelser)
6.6
mateenbhatti94

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 på 1 dag
(95 bedømmelser)
6.6
AnowarRatul

---------------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 ab Flere

$89 USD på 1 dag
(166 bedømmelser)
5.9
dhanrajkarthick

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 im Flere

$101 USD in 7 dage
(29 bedømmelser)
4.8
nemanjadj20

Hello?"Dear Douglas" I have worked on Excel/Word/PPT/MACRO projects to what you are looking for, and I am confident I can exceed your expectations. I have attached samples of work very similar to what you are seeking Flere

$155 USD in 3 dage
(8 bedømmelser)
4.9
Mokshith30

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 på 1 dag
(44 bedømmelser)
4.7
fadeevdoma

⭐⭐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, Dashboa Flere

$150 USD in 7 dage
(2 bedømmelser)
3.3
swarnali2017

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 i Flere

$91 USD in 3 dage
(8 bedømmelser)
3.4
Jatin77777

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 2 Flere

$150 USD in 2 dage
(6 bedømmelser)
2.9
chrisklick

Dear Douglas Hello I have much experience in Excel MACRO development. I can start from now on and will deliver quality work asap. Lets discuss more detail via Chat. Hope to hear from you soon. Best Regards.

$211 USD in 7 dage
(1 bedømmelse)
3.1
KPrafful

"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 I Flere

$151 USD in 3 dage
(3 bedømmelser)
2.3
shish1992

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 in 7 dage
(5 bedømmelser)
2.9
neonshare2

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 in 7 dage
(1 bedømmelse)
1.2
rameshraja86

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 pr Flere

$151 USD in 2 dage
(2 bedømmelser)
0.6