View Single Post
 
Old 12-05-2017, 06:23 PM
yoyo4 yoyo4 is offline Windows 10 Office 2013
Novice
 
Join Date: Nov 2017
Posts: 14
yoyo4 is on a distinguished road
Default Automatically delete row based on keyword-VBA

HI,
Need to automatically delete row that contain certain keywords.
Example -:
i have data sheet with 5 column.(Name,Last Name,Company Position,Email Address ,Phone Numbers )
If any of keywords are located in any cell (as part of a word, email, address, job title, company, etc,) need to delete the row automatically.
(keywords-loan,financial,bank,equity)

Thank you.
Reply With Quote