Search Column and Selecting Rows with Matching Text

Hey all,

I've been trying to figure out a VBA for the following but I'm not having much luck. Much love if you could help!

I'm trying to see if column AG includes certain text, such as "bar". For each positive match in this column I'd like to select the entire row and copy said row to another spreadsheet.

Please let me know if you can help or need further clarification!

Thanks so much!

Originally Posted by xladept

Hi,

Welcome to the forum - try this:

Please Login or Register  to view this content.

Thanks so much, you've already been so helpful! I'm getting error 13 mismatch on:

Please Login or Register  to view this content.

Any ideas?

You Are A Genius!

This works wonders!!!! Thank you so much. Really saving me so much time. : )