That should be Advanced Filters, not Data Validation.

"M.A.Tyler" wrote:

Is it possible for data validation to overwrite an existing sheet? I'm using
a macro to extract rows to a second sheet, it has space for 12 possible rows.
If the extraction is less than 12 rows, say only 8, the balance of the rows
would be already populated. Not from the last use, but from a reset button
that populates the "copy to" field with 9's. This data is then moved to a
third sheet that uses 9's instead of blank cells. Currently I'm receiving an
error when I try to overwrite the populated cells.

I know it sounds crazy, but thats the way it was set-up?

Thanks in advance.