GOT this: application-defined or object-defined error"
then at the botton 3 tabs:
END DEBUG HELP
none of then worked.

"computexcel" wrote:

DID that before your answer and got " something about DEBUGER"

"Debra Dalgleish" wrote:

Right-click on the sheet tab, then click on View Code.
Copy the code that's there
In your workbook, right-click on the sheet tab and click View Code
Paste the code that you copied from the sample workbook.

computexcel wrote:
YES, THAT'S IT.
Exactly what I need. How can I do this, I'm sure is thru VBA.

"Debra Dalgleish" wrote:


There's a sample file here that uses programming to filter by the
selected value:
http://www.contextures.com/excelfiles.html

Under Filters, look for 'FL0021 - FilterClick'

In the sample file, click on a cell in the filter range to filter that
column by the selected value. Click on a column heading to remove that
column's filter.

computexcel wrote:

I have a very large data of names autofiltered.
I learned to drop down, then, write the first letter and go alphabetically
by that letter if I want to.
However, in some letters ( ex R) they are a lot of names starting with R.
Before doing autofilter, I have to work down the worksheet column by column
and then autofilter to find all names that are the same.
This is complicate it to explain but here goes :
Is there any way or trick I could use that, when my ACTIVE CELL says for
example
RANEIRO, then going to drop down in the top autofilter and select all RANEIRO
instead of looking it in the extense dropdown list.
THANKS


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com





--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com