Excel Macro to copy an entire row from one sheet to another based upon a single word, within a parag

Posted by jason on Stack Overflow See other posts from Stack Overflow or by jason
Published on 2010-04-13T13:59:06Z Indexed on 2010/04/13 14:33 UTC
Read the original article Hit count: 470

Filed under:
|
|
|

Guys i'm looking for a simple excel macro that can copy a row from one sheet to another within excel based upon having a specific word in the cell. I have a sheet one, called "data" and a sheet two called "final". Here is an eaxmple of the data

A         B            C               D  
john      mary         555.555.4939    initial reply to phone conversation  
Jim       jack         555.555.5555    floor estimate for bathroom  
jerry     kim          555.555.5553    initial response to phone call

I'd like to copy than entire row from sheet "data" to a sheet "final" if the data in column D contains either the word "reply" or the word "response" somewhere within the paragraph.

Any tips would be much obliged.

thanks, J

© Stack Overflow or respective owner

Related posts about excel

Related posts about macro