I'd apply data|filter|autofilter and use that to show the rows I wanted to see.
I wouldn't create another copy.

But if you had to, you could copy the visible rows and paste into any other
worksheet you wanted.

d_kight wrote:

I am wanting to be able to take a row of data that ends with a date and based
on the date move that entire line to another sheet or to a specific location
on my drive:
for example

A B C
D
1] john Dee enter ga-01
06/05/2007
2] jane lane outer ga-02
07/10/2007
3] dan land enter ga-01
08/01/2007
4] Pea Body enter ga-01
07/26/2007

Now I want to capture the dates in column D that are after 07/01/2007 and
list them in order on another page.

--

Dave Peterson