Suljettu

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.

Deliverables

Vba code

Taidot: Excel, Excel VBA

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Toronto, Canada

Projektin tunnus: #31001025

27 freelanceria on tarjonnut keskimäärin $26 tähän työhön

(1026 arvostelua)
8.2
(372 arvostelua)
8.1
(352 arvostelua)
7.3
(305 arvostelua)
7.4
(221 arvostelua)
7.0
ksriniravi

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 Lisää

$20 CAD 1 päivässä
(220 arvostelua)
7.0
(87 arvostelua)
6.2
rIbrarahmed

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 Lisää

$20 CAD 1 päivässä
(26 arvostelua)
5.1
reubengi

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 Lisää

$25 CAD 1 päivässä
(21 arvostelua)
5.0
osamawebjuggler

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

$89 CAD 1 päivässä
(19 arvostelua)
4.3
(38 arvostelua)
4.1
marfan080

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] Lisää

$20 CAD 7 päivässä
(21 arvostelua)
3.6
Blackeagle8

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 Lisää

$20 CAD 1 päivässä
(6 arvostelua)
2.0
imaditya92

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 Lisää

$20 CAD 2 päivässä
(2 arvostelua)
1.4
eagleeyesvw

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 2 päivässä
(0 arvostelua)
0.0
Lighting89

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 Lisää

$12 CAD 3 päivässä
(0 arvostelua)
0.0
gryndanya

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

$20 CAD 2 päivässä
(0 arvostelua)
0.0
jalpizar07

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 1 päivässä
(0 arvostelua)
0.0
hatou1227

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 Lisää

$30 CAD 1 päivässä
(1 arvostelu)
1.0
hermanolustosa

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 Lisää

$25 CAD 1 päivässä
(0 arvostelua)
0.0