View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jman Jman is offline
external usenet poster
 
Posts: 110
Default Advanced Filter to another location

I want to filter out clients that i have seen this year only( i have
thousands of clients).
How can i filter the clients from sheet1 to sheet 2.
ex

Sheet1

A1
Julian Mcather
Chris baker
Dan baker

B2
1-12-07
2-02-02
3-3-07

In sheet2
All i want is the names of clients of this year 2007 ( if possible to show
me how to change the year to 2008 when this year ends,, so i don't have to
but you guys next year"

A1
Client names only
Julian Mcarther
Dan Baker