Copy and Paste Entire Row from Sheet1->Sheet2 based on text string match in Sheet1 Row

[dmlovic]

I have looked all over this board for the solution and found numerous things that *almost* worked, but none did. So frustrated right now that I decided to just post and see if someone can help me out.

I'm not a programmer, but understand the concepts from Test Automation, javascript, etc...

I have such a simple problem.

I have an Excel sheet with text content ONLY in ROW A -- about 400 rows.

I need to search each row for three phrases: "[info] Executing: |echo", "[info] echo: true" and "[info] echo: true".

If any row is a match, I want that row copied and pasted into Sheet2, one after the other.

That's it. So conceptually easy, but I'm feeling like a big moron that I can't figure it out.

Sample excel file is attached. THANKS!Results_File.xlsx

[watersev]

hi dmlovic, welcome to ExcelForum, VB option to make it, please check attachment, press "Run"

[dmlovic]

A million times "thank you."

You have just taken a weight off of me as I go home for the evening.

David

[dmlovic]

I just realized that I messed up what I originally posted. The third condition is supposed to be "[info] echo: false" so that there's 3 conditions. Ugh. I tried doing what seemed to make sense, which is:

With .Range("a1:a" & lrow)

.AutoFilter 1, "[info] Executing: |echo*", xlOr, "[info] echo: true", xlOr, "[info] echo: false"
.Offset(1).Copy Sheets.Add(after:=Sheets(Sheets.Count)).Range("a1")
.AutoFilter

End With

But obviously, that's not the answer. Can you help?

[watersev]

please check attachment, press Run

[dmlovic]

Works perfectly.

If you have a PayPal address, I'll send you $5.

Thanks.

[watersev]

thanks is enough