Hi Todd

This depends on Why and How Often. But I'd go menu Data Filter
Atrofilter, then choose X in the column dropdown that appear in the column
header cell. from there copy-paste, subtotal or whatever I want done.

Another approach is to create a Pivot Table with the column in question as a
page field.

HTH. Best wishes Harald

"Toddmend" skrev i melding
...
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