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

Habilidades: Excel, Excel VBA

Veja mais: 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

Acerca do Empregador:
( 0 comentários ) Toronto, Canada

ID do Projeto: #31001025

27 freelancers estão ofertando em média $26 nesse trabalho

(1026 Comentários)
(372 Comentários)
(352 Comentários)
(305 Comentários)
(221 Comentários)

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 Mais

$20 CAD em 1 dia
(220 Comentários)
(87 Comentários)

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 Mais

$20 CAD em 1 dia
(26 Comentários)

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 Mais

$25 CAD em 1 dia
(21 Comentários)

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

$89 CAD em 1 dia
(19 Comentários)
(38 Comentários)

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] Mais

$20 CAD in 7 dias
(21 Comentários)

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 Mais

$20 CAD em 1 dia
(6 Comentários)

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 Mais

$20 CAD in 2 dias
(2 Comentários)

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 dias
(0 Comentários)

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 Mais

$12 CAD in 3 dias
(0 Comentários)

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

$20 CAD in 2 dias
(0 Comentários)

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 em 1 dia
(0 Comentários)

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 Mais

$30 CAD em 1 dia
(1 Comentário)

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 Mais

$25 CAD em 1 dia
(0 Comentários)