Copy row if cell value equals string - All worksheets in book to new sheet

Hello-

I would like to use VBA to review column A in all sheets in a workbook. If "EDIT_NAME" and/or "EDIT_DATE" are found, copy those row(s) to a new sheet, along with the sheet name from which they were copied. Some sheets might have both instances, one or none.

There are few great examples in this forum that look perfect but I can't hack them to work into my case. Specifically this solution by Trebor76: http://www.excelforum.com/excel-prog...cent-cell.html My VBA skill is non-existent and im hoping to use this as an opportunity to learn. Thank you for any help you can provide.

See attached example workbook : EditFields_Info_Example.xlsm

Wow, great work Robert. Thanks for the reply. This works as expected. I really appreciate your help.

Here are some ways the search for variables could be expanded:

Search for 3 strings in column A:

Please Login or Register  to view this content.

If I want to include a wildcard:

Please Login or Register  to view this content.