Looking for some help on this one:

I have a combobox on Sheet1 that has multiple names available.
Whatever name is selected is linked to cell A1. On Sheet2, I have th
same names listed in row A. What I want to do is when a name i
selected in the combobox, I want to go to Sheet2, find the cell in ro
A that has the matching name, and then pick the AutoFilter button tha
is in the same column but 4 rows down from the name, and filter o
(NonBlanks).

Any help is greatly appreciated...thanks

--
clmarque
-----------------------------------------------------------------------
clmarquez's Profile: http://www.excelforum.com/member.php...fo&userid=2938
View this thread: http://www.excelforum.com/showthread.php?threadid=49173