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
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