View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
d_kight d_kight is offline
external usenet poster
 
Posts: 13
Default capturing Data and printing line elsewhere

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.