Advanced Filtering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Well I have my data set up so that I can extract it to another sheet. I go thru advance filtering once for my current weeks data to look for duplicates. Then I copy those duplicates go back to the criteria and paste it, I run advance filter again and bam I have all the duplicates with that address. Just what I Was looking for
1. Is there a faster way of doing this. (since I added more rowsto criteria, and I am copying to another sheet, the list range does not populate automatically I have to highlight it
2. I would also like to have my current week filter in to the same page as my duplicates. is there a command that I can put in the criteria that tells it filter in these nine records and also this weeks data
Criteri
TYPE | ADDRES
20030303
104 Park Ct
25540 S. Canal St
1813 Burry Cr
What can I put in front of the date thot would filter the data for that week also into my extracted sheet

Thank
 
If you are only trying to retrieve a group of rows with the same address in
one cell, probably the AutoFilter would be quicker and easier than the
AdvancedFilter...........

Vaya con Dios,
Chuck, CABGx3



Oscar said:
Well I have my data set up so that I can extract it to another sheet. I go
Click to expand...
thru advance filtering once for my current weeks data to look for
duplicates. Then I copy those duplicates go back to the criteria and paste
it, I run advance filter again and bam I have all the duplicates with that
address. Just what I Was looking for.
1. Is there a faster way of doing this. (since I added more rowsto
Click to expand...
criteria, and I am copying to another sheet, the list range does not
populate automatically I have to highlight it?
2. I would also like to have my current week filter in to the same page as
Click to expand...
my duplicates. is there a command that I can put in the criteria that tells
it filter in these nine records and also this weeks data?
Criteria
TYPE | ADDRESS
20030303
104 Park Ct.
25540 S. Canal St.
1813 Burry Cr.
What can I put in front of the date thot would filter the data for that
Click to expand...
week also into my extracted sheet?
 
Back
Top