Hi everyone,
I have a problem with my Advanced Filter Macro which doesn't seem to be working properly. When I had only a few criterias it worked like a charm but since I have added several others it seems to not filter correctly.
I have attached the file. It shouldn't be protected anymore but if it asks for a PW it is "Online". Tax_Ruling_Directory_NEW.xlsm
In advance many thanks for your help!
What is it you are actually trying to do within the worksheet(s)?
If you are happy with my response please click the * in the lower left of my post.
Hi stnkynts
In the Interface sheet one can specify in the fields C6:AE6 the filter. Once the user clicks on Filter Data Excel displays the entries from the sheet Data that correspond with the chosen criterias from C6:AE6. The results are displayed in C8:AR8.
Many thanks for your time!
EDIT:
Somehow, when I make the Criteria Range larger, from CriteriaRange:=Range("AS4:AX5") to CriteriaRange:=Range("AS4:AY5"), that's when the Filter Data stops working and no results are displayed when clicked on Filter Data button.
Last edited by etaver87; 02-12-2016 at 12:03 PM.
So you are essentially trying to filter columns not rows (which is an issue) by the column header and copy those specific headers, with all the rows, to another sheet?
Yes, exactly. It worked really well at one time but suddenly not anymore. I think it has to do with the columns that have either FALSE or TRUE as values. Do you know a workaround to make the filter work?
Change CriteriaRange:=Sheet1.Range("AS4:BU5") to CriteriaRange:=Sheet1.Range("AS4:BU4")
in that case, he just displays all data from the Data sheet.
I thought that is what was desiredin that case, he just displays all data from the Data sheet.
Well, once I hit Filter it just copy & pastes the whole data from the Data sheet without filtering. It should filter according to what is specified in the Interface sheet in cells C6:AE6 .
I tried adding the number of criteria step by step in a new file:
Attachment 446483
The filter Macro is the following in that new file:
Now, if a leave the criteria range like this the filter works great. However, as soon as I extend the criteria range to one more cell, i.e. CriteriaRange:=Range("M5:T6"), the filter stops working. It is very strange.
Please Login or Register to view this content.
Well, once I hit Filter it just copy & pastes the whole data from the Data sheet without filtering. It should filter according to what is specified in the Interface sheet in cells C6:AE6 .
I tried adding the number of criteria step by step in a new file:
Template-Tax-Time.xlsm
The filter Macro is the following in that new file:
Now, if a leave the criteria range like this the filter works great. However, as soon as I extend the criteria range to one more cell, i.e. CriteriaRange:=Range("M5:T6"), the filter stops working. It is very strange.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks