Please help with VBA to search through same column on different worksheets in a workbook

[damilaredavids]

Hi guys, I wonder if you can help with a VBA-related issue I have,

I have a workbook containing spreadsheets (with over 50,000 rows). One of the columns (for e.g. column B contains the data i need to search from).

I need to search column B for certain words and if true, the row should be copied out onto a separate sheet. I also want to be able to search the column of cells of text for all cell that contain for example the word "tre" AND "flo" if i was looking for "tree" AND "flower".

So all results must find cells that have tree in the body of text and the row where the search term is found would be copied to a separate worksheet. I have inserted a sample sheet.

Thank you for your help.

[p24leclerc]

Here is a macro that should do it:

Please Login or Register  to view this content.

See attached file with macro included.