Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Can I gets avaliable list of all criteria in autofilter
Hi all!
It seems to me that my last question about criteria wasn't considered :( I read this http://www.j-walk.com/ss/excel/usertips/tip044.htm but it's not That I'll now one more try explain my problem link to file http://aljany.com/Criterias_.jpg and my example file is here http://aljany.com/My_Book.xls The first column contains years, the second contains month. On these columns Autofilter is applied. There is a form of input of filter for users. In it we choose a year, for example 1977. Excel will filter on a year the first column and will rotin in Autofilter in the second column collection from months, for example «august, september, june» are avaliable. How to get this avaliable criteria values? If the program chooses in form input in listbox these three months, and I will choose july for example. Now in form input an only one month - «july» will appear in listbox. And I need all of variants months on 1977 year. How to take them all avaliable criteria from the list of Autofilter? How to get this? In fact Excel it as did do that? Help me please in it :( Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Can I gets list of all criteria in autofilter for any column | Excel Programming | |||
Selection.AutoFilter Field / Criteria = criteria sometimes non-existing on worksheet | Excel Programming | |||
How to loop (or list) all the criteria in autofilter | Excel Programming | |||
Get the list from Autofilter after filter some criteria | Excel Programming | |||
next avaliable range | Excel Programming |