Autofilter

[computexcel]

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

 

[Dave Peterson]

Maybe you could use a helper column and one of the techniques at Debra
Dalgleish's site:
http://contextures.com/xlautofilter02.html#Limits

 

[Debra Dalgleish]

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]

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

 

[computexcel]

Thanks for your help Dave, information and website are very useful for me,
however the issue goes to "quicker filtering" and probably will need VBA.

 

[Debra Dalgleish]

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]

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

 

[computexcel]

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

 

[Debra Dalgleish]

If you can give the exact error message, someone might be able to help.

 

[Debra Dalgleish]

The code checks the On/Off cell to see if it should run the code.
Copy that cell to your worksheet to, and name it FilterStatus.
There are naming instructions here:
http://www.contextures.com/xlNames01.html

 

[computexcel]

The error was already stated it.
However I just missed to copy and paste the ON/OFF cell and name it.
Now it works perfectly. Thanks Debra.