how to apply filter based on list or combo box??

[Jon]

Hi,

I have a list of numbers example,
In a2
1
2
1
3
3
4
2
2
2
What I want to do is create a combo box in a1 that has a list 1, 2 ,3, 4.
Once the user select e.g. 1 , auto filter will be applied on the range from
a2 to ….. showing only cells that have 1 . how to do that??

 

[JCS]

Hi Jon,

Try this (Excel 2003):

1. Select A1
2. From the menu bar select Data, Filter, and then AutoFilter. If I
understood your requirement, this should do the trick. Press YES if this
posting helped.

John

 

[JCS]

Hi Jon,

Try this (Excel 2003):

1. Select A1
2. From the menu bar select Data, Filter, and then AutoFilter. If I
understood your requirement, this should do the trick. Press YES if this
posting helped.

John