View Single Post
 
Old 12-05-2017, 04:56 AM
yoyo4 yoyo4 is offline Windows 10 Office 2013
Novice
 
Join Date: Nov 2017
Posts: 14
yoyo4 is on a distinguished road
Default How to write VBA in following example

Hi all,

Need to automatically delete row that contain certain keywords.(keywords-loan,financial,bank,equity)

i have data sheet with 5 column.(Name,Last Name,Company Position,Email Address Phone Numbers )If any of above keywords are located in any cell (as part of a word, email, address, job title, company, etc,) need to delete the row automatically.