If cell = x (mixed with other character in a cell) then copy paste row

Maybe, you need something like:

If InStr(1, Cells(x, 5), "GW") > 0 Then

Thanks for the reply!

i am not that familiar with vba i only understands little of it. what i did with the code you gave is replaced the, existing *If Cells(x, 5) = "GW" Then* but nothing happens. Please let me know if i am doing it in a wrong way? and if there's any other way we could add something like a * (asterisk) to the existing code to search for the specified "GW" even it has other text inside a cell like "*GW*".

Hi Makko, try it

Please Login or Register  to view this content.

Hi Mr. nilem,

I tried working on your code and honestly i understand only few on your code hehe ... i guessed i really need to try harder to learn
VBA.

Your code is working perfect and i like to use it and replace the old code i have... the only problem i have now is the sheets now are
modified and has a Column Tab and Header which should be bypassed by the search and paste. Now my Newbie-ness really gone to the highest level

I've modified your code a little to get it working on a search row that was on the 5th column (now on the 7th) but bcoz of the
Column Tab and Header, the pasting on the other sheet is not in the right position anymore and the code is only pasting 5 columned data.

I attached a file for reference of the problem. Your help will be very much appreciated please... thanks in advance to all here!!!

If the "Action By:" column has a value "GW / TH", the entire string must be copied on sheets of "Engineering & INTF (GW)" and "Process (TH)". Right?

Thanks for the reply Mr. Nilem, intentional reply to your post but posted it in the reply to thread..

Mr. Nilem,

Yes exactly!

Note: Please disregard the #7th reply to thread before this...

OMG! you are a star! thank you very much! i am very much surprised for this short period of time the issues are solved... this is what i really needed. You did everything for me.

i only have one more question what is "(946, 1)" means?

please continue on helping other people GODSPEED to YOU!!!

B946 cell contains "*" and the expression

Please Login or Register  to view this content.

will return to us the last filled cell, ie B946
So we use the Cells(946, 2).End(xlUp), to obtain the desired cell, ie B9.

And the A946 cell is empty, and the expression

Please Login or Register  to view this content.

will return to us the last cell, ie A9

Thanks once again to hope i could be just good as you have a blessed life to you and your family!!!