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
|