find and replace help with copy paste
 

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.

find and replace help with copy paste
 

Are they all in one column? If so, you can use DataFilter.

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.

"Alex43" wrote in message
...
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.