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!