• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple Filter

V

vamshikrishna

New Member
Hi All,

I have data, like sastisfied, verysatisfied and dissatisfied, but some time the data may vary like it wil be only satisfied, or verysatisfied, i want to write a macro for this
 
Hi
thank you, but i dont know whether the data will be there or, here we setting the values, some times
 
Last edited by a moderator:
vamshikrishna
so?
If data is there then verysatisfied.
If data is somewhere then ... You could modify macro to be satisfied.
It'll be challenge nobody don't know where ... disatisfied
It would be better if fixed place.
 
How to search the Data and Filter based on Availability, LIke i have column

A, B C D F, in this E is not available, i have to search A and E, as A is available it has to filter only A
 
vamshikrishna
As in #4 i dont know whether the data will be there or, here we setting the values, some times
Do You know now better?
With original case ... there were no 'Availability' nor 'not available'.
If You know
then make a good sample file with data
which would show You new named case ... and upload that file here.
 
Attached the Excel File

1 scenario

Sastisfied and Very Satisfied

2nd Scenario

Disatisfied and Very Disatisfied, Neutral

but for the Neutral is not availble as of now, it may add anytime

i want the code when it is available it has to select, if not no need to be check
 

Attachments

  • test1.xlsx
    9.2 KB · Views: 2
Last edited by a moderator:
i dont want it to be on excel and select, by default it has to filter based on the availability,

anyways how to create that values to selelct, so that i can implement in my sheet
 
Last edited by a moderator:
vamshikrishna
When would You start to answer questions?
If You only want something and You cannot give even answers then ...
Hmm ... now You don't want something to be on Excel ... hmm?
and so on ... what would You mean?

You can 'write' to those bordered cells any words
... after You'll know what to write!
 
ActiveSheet.ListObjects("Table15").Range.AutoFilter Field:=16, Criteria1:= _
"=Satisfied", Operator:=xlOr, Criteria2:="=Very Satisfied"
ActiveSheet.ListObjects("Table15").Range.AutoFilter Field:=16, Criteria1:= _
Array("Dissatisfied", "Neutral", "Very Dissatisfied"), Operator:=xlFilterValues

see in the first condition what is happening evening it find two values, or single value, it is filter, but in the second condition, if any of the value is missing it is not filtering, i want to make the code like first one and i tried with the following code but not working

ActiveSheet.ListObjects("Table15").Range.AutoFilter Field:=16, Criteria1:= _
"=Dissatisfied", Operator:=xlOr, Criteria2:="=Neutral", Operator:=xlOr, Criteria2:="=Very Dissatisfied"
 
I want to use the below code dynamically
Windows("Fujitsu Satisfaction Survey grouped by incident.xlsx").Activate
i mean, i want to set the filename in any cell of Excel and from that cell it has to window name, can it is possible
 
You must log in or register to reply here.
Back
Top