I'd apply Data|Filter|Autofilter
Use a custom filter of equals X (or contains X--depending on what you meant).

And then copy those visible rows and paste to the new worksheet.

Toddmend wrote:

What statement would I use if I want to search a exce data base and find all
rows that have "X" in one colum. I want to take those rows that contain "X"
and copy the entire row into another excel document. Any ideas?
--
Todd

--

Dave Peterson