If Statement help (I think)
 

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

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

One way
Use DataFilterAutofilter
Select the drop down on the column containing your "X's" and select X
Select the filtered set of rows and Copy to your other sheet.
--
Regards
Roger Govier
"Toddmend" wrote in message
...
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

But I want this database to be an ongoing one where I won't have to cut and
paste somethign every time I change the main database. So in theory I would
like to add rows of data to the database, and if one specific colum shows up
with "X" it will automatically copy it to the "X" file which is a seperate
file. The reason is I want a seperate file to see every row, and all of it
for the rows that contain "X" in that one column.
--
Todd


"Harald Staff" wrote:

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