Dear All,
I written small VB code to check codes are existing in other sheet or not.
If code is not exiting in other sheet it should populate "not eligible" instead of "eligible"
I have 3 sheets in workbook (sheet1: 5000 ID's along with other columns as a PIM and column A as a PIM1 / sheet3...