first, apologies english. have user form, user needs select month lets column c using toggle buttons. multiple months should possible selected @ same time e.g. want see results january + february + may. filtering multiple columns multiple criteria , @ last column want select more 1 criteria @ time. lets have column names, column b year, column c month , column d product. want achieve user form is, able filter out single name (i have done via combobox+autofilter) want select(filter) year (have done via togglebutton+autofilter) , need filter multiple entries in month column (for example want see products jon doe bought in year 2015 in months of january + may + september. copy these filtered entries (those visible rows) , copy/paste them new sheet.
so have set these "month" buttons, i'm able select 1 month @ time, not multiple. can please advise how can accomplish ? if toggle buttons not way selection, please advise other.
i thought out of not using auto filter month column, use like: filtered rows go down , find string "january" or "may" or "september" within visible rows , when find such row mark it(or select it) , continue searching until first empty row. copy rows match search criteria , copy/paste them "new sheet".
but i'm beginner lama , can't find way of doing right. please advise.
autofilters allow multiple selection. recording macro give code need that.
in userform, there should property of listbox allows multiple selection well.
should relatively straightforward exercise of looping through selected items in listbox , applying criteria autofilter.
Comments
Post a Comment