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.
27 freelancers are bidding on average $26 for this job
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.