I have a data which I would like to filter, I decided to go for Advanced Filter.
A simple example, in the given sheet I have data in 6 columns and I would like to have the filter as
Channel = 1 or 2
Mode = diff
Temp = 25 or 85
Reference = 6 or 7
Vdd = 2.25
(Please note that I can have many conditions here and hence Autofilter can not be used) If I have to have an autofilter for this it should look like the yellow box on the "FilterConditions" Sheet.
My questions is how do I write a VBA program to do this, I would want to find all combinations and put them in proper order by choosing 1 from each column at a time.
I am also not sure how many conditions would be available (I can decide the max though, let say 10 if someone needs it)
Any help would be highly appreciated.
Thanks
Mohit
Bookmarks