But I want this to be an ongoing database. I would like it to be a formula
where I can enter something inew n the main database, and then if it has "X"
in that colum, it will automatically be brought to the "X" file (which is a
seperate file)
--
Todd


"Dave Peterson" wrote:

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