Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter to another location
Introduce another column with the formula:
=YEAR(B2) and copy this down. Apply the filter to this column to select your year, then highlight the visible names and copy them to the other sheet. Hope this helps. Pete On May 29, 10:30 am, Jman wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter to another location
Hi
On sheet2 in cell B2 enter ="="&"01/01/2007" You must begin the AF from Sheet 2, if you are wanting to copy to another location. DataFilterAdvanced Filter (ignore the warning message) Source Sheet1!$A$1:$M$1000 Criteria $B$1:$B$2 click the Copy to another location Destination $A$5:$M$5 I am assuming that there is more data than just columns A and B, hence I have used a range going from column A to M. Adjust according to your circumstances. Next year, just change the value in cell B2 -- Regards Roger Govier "Jman" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter to another location
In addition to Roger's comments, the columns on Sheet1 should each have
a heading. And cell B1 on Sheet2 should have the same heading as the date column on Sheet1. Roger Govier wrote: Hi On sheet2 in cell B2 enter ="="&"01/01/2007" You must begin the AF from Sheet 2, if you are wanting to copy to another location. DataFilterAdvanced Filter (ignore the warning message) Source Sheet1!$A$1:$M$1000 Criteria $B$1:$B$2 click the Copy to another location Destination $A$5:$M$5 I am assuming that there is more data than just columns A and B, hence I have used a range going from column A to M. Adjust according to your circumstances. Next year, just change the value in cell B2 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter to another location
Thanks Roger, Pete and Debra, it worked...you guys are awesome.
"Debra Dalgleish" wrote: In addition to Roger's comments, the columns on Sheet1 should each have a heading. And cell B1 on Sheet2 should have the same heading as the date column on Sheet1. Roger Govier wrote: Hi On sheet2 in cell B2 enter ="="&"01/01/2007" You must begin the AF from Sheet 2, if you are wanting to copy to another location. DataFilterAdvanced Filter (ignore the warning message) Source Sheet1!$A$1:$M$1000 Criteria $B$1:$B$2 click the Copy to another location Destination $A$5:$M$5 I am assuming that there is more data than just columns A and B, hence I have used a range going from column A to M. Adjust according to your circumstances. Next year, just change the value in cell B2 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter - filter rows < | Excel Discussion (Misc queries) | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |