I've tried looking through the forum for this but I can't seem to find anything that suits what I need.
I need to create a macro which selects all the rows containing a specific word in column A then pastes these rows into another worksheet.
I don't know if it's worth mentioning that column A will already be in alphabetical order, so the text strings will already be grouped together one rows after the other.
The logic of the macro would be as follows:
Find all cells in column A containing word "Banana"
Select entire rows
Copy all these rows to worksheet "Sheet2"