Search a range of data cells for text.

[bbran19]

Hi,
I am looking for the code to search a range of cells for a particular text and copying the cells that contain that text into another location.

Is that possible?

Cheers

Bob

 

[My Aswer Is This]

Yes using a Vba Macro.
We need to know:
1. The range to search.
2. The value to look for
3. The location to put the results.