Hello guys,
I am looking for a VBA code, to do the following. Can someone please help. Thank you.
1)Compare 2 sheets (Column J of sheet "Data" Vs Column B of sheet "Expected outcome")
2)If the cell content in Column J is not found in Column B (Case insensitive).
3)Copy the cell content of Column J to Column B below the next available blank cell.
4) In the next adjustment cell "No data" standard text should be entered for the newly copied data set.
I have attached the sample workbook, the red font in the "Expected outcome" sheet should be the output.
Bookmarks