PDA

View Full Version : Solved: filter



oleg_v
07-11-2010, 05:54 AM
hI

i need some help
in the worksheet i have an auto filter working i filter the data according to the data in column "a" is it possible to build a combo box to control the filter .

Bob Phillips
07-11-2010, 08:17 AM
See http://www.contextures.com/excelfilesRoger.html and scroll down to FastFilter

oleg_v
07-11-2010, 10:07 PM
hi

i saw but it not what i need what said i need a combo box to be connected to to column "A" and the filter will work by selecting the data from a combo box

i can not attach any samples because i do not know how to do this

Aussiebear
07-12-2010, 12:37 AM
Click on Go Advanced | Manage Attachments and upload the file, or image.

Aussiebear
07-12-2010, 12:40 AM
I have been to the site reccomended by XLD and believe that you can filter quite easily using this method. Do you require the listbox because the user will not remember what to search for?