Need help with a quick VBA project with Excel
Budget: $10 – $30 CAD
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
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