If (value in cell != any date) copy entire row into new worksheet

[moremetrics]

I was hoping to find this answer in the threads, but I'm running out of time!

I need to automate a process to create a new worksheet from an existing worksheet that shows only certain rows based on whether or not there is a date in the last cell of that row. I am not sure if a macro or formula would be best for this. The original worksheet will be updated frequently, and my management only wants to see those items that are still open.

For entire worksheet:
If (value in column K is not equal to a date)
Copy the entire row into a new worksheet (append to last row copied into new worksheet)

Any help would be greatly appreciated!

[moremetrics]

Hi again!

I'm having problems with advance filter now. I figured out that I can probably use this to copy to another worksheet.

My value range is $A:$K
My criteria range can be less than todays date - today()
My copy to will be another worksheet

But I'm getting an error..."Reference is not valid"

=) Lia

[moremetrics]

I figured out to copy to another sheet, but my criteria is wrong because it is copying all rows.

I have one worksheet named "Drawing Status" and another one named "Open Drawings."
Example of data on "Drawing Status":

Drawing Number Status Date Released
1 blah blah
2 blah blah 5/2/2005
3 blah blah
4 blah blah n/a

I then set this filter up in "Open Drawings"

ok....after writing this I realized that my criteria is wrong. I need to figure out if it can find those rows that have anything BUT a date in the Date Released column.

Thanks....Lia