Hello,
I need a code that searches for only red colored cells in column A. and everytime it finds one a pop up should appear with the option to choose a new ID from Table1(maybe through scroll down list or something).
In Col. D, I need another code or formula that tells if a person has graduated or not by referring to table2 and then entering yes or no in Col.D and list the date in E. Maybe this can be done via vlookup formula, but the problem is that the names could be misspelt and thus resulting in #N/A error.
I need a code that searches for only red colored cells in column A. and everytime it finds one a pop up should appear with the option to choose a new ID from Table1(maybe through scroll down list or something).
In Col. D, I need another code or formula that tells if a person has graduated or not by referring to table2 and then entering yes or no in Col.D and list the date in E. Maybe this can be done via vlookup formula, but the problem is that the names could be misspelt and thus resulting in #N/A error.
