--------------------------------------------------------------------------------

Hi,

I would like to know how to use a combo box to perform Autofilter
functions for a particular column, say, column "R".
I need the combo box to have a list of items, e.g.
Apples
Oranges
Bananas
All

so that when any of the item is selected, the column "R" will
automatically be filtered to display only the selected items in another
worksheet in a transpose form. In addition, when the "All" list is
selected, all the items would be displayed under column "R".
Hope to receive some help.


--
ryll
------------------------------------------------------------------------
ryll's Profile: http://www.excelforum.com/member.php...o&userid=28605
View this thread: http://www.excelforum.com/showthread...hreadid=482728