If Statement help (I think)

T

Toddmend

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?
 
H

Harald Staff

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
 
R

Roger Govier

One way
Use Data>Filter>Autofilter
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.
 
T

Toddmend

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.
 
Top