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!