Need macro to check if text in one range exists in another, if yes, insert message box...

Range A2:A50 has names

Range F2:W20 also has names

Check if a name from A2:A50 exists in F2-W20

If Yes, trigger Message Box "Please Unschedule 'the repeated name'" (ok button to accept)

If No, then do nothing

I'm sorry, I explained the problem incorrectly.

C13:C60, E13:E60, G13:G60, I13:I60 and K13:K60 have names (it's a roster of employees).

N23:N150 is a collection of these names.

If a name gets deleted from C13:C60, E13:E60, G13:G60, I13:I60 and K13:K60 it needs to be removed from N23:N150

I currently have a sorting macro that handles that Column. I want to add a command to that macro that does the following:

If a name no longer exists in C13:C60, E13:E60, G13:G60, I13:I60 and K13:K60 but does exist in N23:N150 a message box should be triggered to say "Please Unschedule 'name'"
Blank Spaces should be ignored.

Thanks for your help
Rich

Originally Posted by rcicconetti

If a name no longer exists in C13:C60, E13:E60, G13:G60, I13:I60 and K13:K60 but does exist in N23:N150 a message box should be triggered to say "Please Unschedule 'name'"
Blank Spaces should be ignored.

Please Login or Register  to view this content.

Jindon,

I had to exchange N23:N150 for the range X7:BS55 it gives me a debug error on the "x = Filter...line".
Any suggestions?

Something like

Please Login or Register  to view this content.

Thanks! Works great!