find and replace help with copy paste

[Alex43]

I have an excell sheet with 3500 cells on it. There is 161 cells scattered
thought with the word bicycle...How do i take those 161 results and paste
them into a new worksheet.

 

[Fred Smith]

Are they all in one column? If so, you can use Data>Filter.

Otherwise you would need a macro. But if all 161 cells contain just the word
'bicycle', then why not enter that word in a new worksheet and copy it 160
times? Or what other results did you want?

Regards,
Fred.