G
Guest
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
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