Need help with a quick VBA project with Excel

Request details

Essentially here's what I am trying to get the code to do:

Examine a list of cells in Column A, Sheet1.

For each cell, cross reference the text string (has to match entire cell contents) with a huge list of data in Column B, Sheet2.

There will be anywhere from 0 to 5 duplicates found.

If 0 duplicates are found, write "X" in Column B, sheet1, in the same row as the cell being examined.

Now, if a duplicate found in column B (sheet2), concatenate the contents of columns C and D (in the same row), and put the resulting string one cell to the right of the original cell being referenced (sheet1).

For each additional duplicate, do the same thing, and put each subsequent concatenated string in the same row, one column to the right of the previous one.

I hope this explanation is clear. I will provide a sample of the data.


Vba code

Skills: Excel, Excel VBA

See more: wirting vba project excel, working vba project excel 2007, simple vba project excel, global vba project excel, accessing vba project excel, build vba project excel, make vba project excel, vba project excel codes working application calculator, vba project excel macro, writing standalone vba project excel, tuition vba project excel, need help financial business project, can master page vba project excel, need help continue asp project, password vba project excel, references vba project excel 2016, need help with capstone project

About the Employer:
( 0 reviews ) Toronto, Canada

Project ID: #31001025

27 freelancers are bidding on average $26 for this job

(1026 Reviews)
(372 Reviews)
(352 Reviews)
(305 Reviews)
(221 Reviews)

Greetings! Thanks for very clear explanation of requirements - I understand the same. I can develop a macro exactly as per requirements. Please share the file. Being a full time freelancer working exclusively on Exce More

$20 CAD in 1 day
(220 Reviews)
(87 Reviews)

Hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit mysel More

$20 CAD in 1 day
(26 Reviews)

Hi there, I can write a code for you in Excel that will find the matches and get the appropriate data and populate the columns in sheet 1. I have several years of experience in vba codes and will deliver on time. Plea More

$25 CAD in 1 day
(21 Reviews)

Hi I am expert in excel having experiance in excel and work with 100% accuracy and quality.,,,,,,,,,,,,,,,,,,,,,,,,,,

$89 CAD in 1 day
(19 Reviews)
(38 Reviews)

Hi, I have read your requirements and I am very interested in this project. I have 6 years of experience in this field so I can do this for you at reasonable price. Please feel free to contact me. Portfolio: [login to view URL] More

$20 CAD in 7 days
(21 Reviews)

Hi, Greetings! ✅Checked your project details: VBA project with Excel ✅Completed Time: 24 hours or your required deadline. Kindly, I work on many projects like your request, I can send you many samples of my work in E More

$20 CAD in 1 day
(6 Reviews)

I understood your requirment and can start now and will deliver solution fast. Hire only if your are satisfied with the demo of solution provided by me. I am professional Excel and VBA developer (6+ years of expeienc More

$20 CAD in 2 days
(2 Reviews)

Hi, I am highly experienced in excel and vba. Have worked on sheets like that. Provide excel to work with. Regards Eagle Eyes

$25 CAD in 2 days
(0 Reviews)

Dear Sir/Madam, I would love to assist you as after reading the complete project description carefully! i found myself as the best match for your requirements. i’m EXCEL expert , having more than 5 years of experience More

$12 CAD in 3 days
(0 Reviews)

VBA developer experience over 4 years I can start working immediately. Let's discuss details in chat. Thanks

$20 CAD in 2 days
(0 Reviews)

I am an expert in the Microsoft Excel environment with 10+ years of experience, using formulas and VBA to create innovative solutions is part of my day to day work.

$25 CAD in 1 day
(0 Reviews)

Hi, Dear! I have a full experience of 7 years in Excel VBA. I have read your requirement carefully and I am interested in this project. If you`ll choose me, I am confident to provide you best solution that completely More

$30 CAD in 1 day
(1 Review)

Hello Your explanation is very clear and straightforward. Some simple questions: When you say huge list, do you mean how many rows? It would be ok if we put a nice button to trigger the execution of the task? Best r More

$25 CAD in 1 day
(0 Reviews)