Hello all,
I'm relatively new to VBA and I've been learning through trial and error and other posts on this forum for the past 4 or 5 months. I have run into a problem that I cannot seem to solve no matter how much I tweak different .find or if statements.
I need a VBA script that will search through columns Q and R for cells containing the words "terminated" "termination" "resigned" "resign" "redundant" "released" or "cancel enrollment" that appear in larger text strings like: "Employee resigned on 10/01".
I need the entire rows where these cells are located to be copied, pasted onto a seperate sheet, and then deleted off the original sheet.
Any help or suggestions would be appreciated or links to similar threads (I've searched through a lot).
Thanks!
Bookmarks