LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Process a row if a string search finds certain words from a list

Hello!
I have a list of real estate ads (text) in a column (column B). It has over
300 rows. I want to delete every row that has certain pre-defined words in
the ad text; eg. realtor, property, management, etc. The list of words I
would like to search for is a variable list that I may add to over time. So
I'm thinking of having a separate sheet ("'exclusions") that has all the
words i want to look for in its column A.

So I would like to have a macro that does the following (below is in pseudo
code):

for each word in "exclusions"(a:a) do
for i= 1 to lastrow do
if cell B(i) contains word then
delete row
end if
end for

Am I making sense? Again, the ad text is of variable length, and i'm
looking to find certain words based on a list located in another sheet that
may change.

Thanks very much in advance for any/all help! :)



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search a string in a cell for a list of 3 letter codes SteveT Excel Worksheet Functions 3 November 7th 08 03:11 AM
search if a string contains text matching items in a list neil Excel Worksheet Functions 3 March 11th 08 09:13 PM
How do I do a multiple search using key words in a text string patricia tipp Excel Discussion (Misc queries) 1 February 28th 06 05:01 PM
to search for a string and affect data if it finds the string? Shwaman Excel Worksheet Functions 1 January 11th 06 12:56 AM
need IF function to return 0 if it finds a one out of three words aledger Excel Worksheet Functions 3 March 1st 05 12:47 AM


All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"