Autofilter

  • Thread starter Thread starter computexcel
  • Start date Start date
C

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
 
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.
 
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.
 
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.
 
GOT this: application-defined or object-defined error"
then at the botton 3 tabs:
END DEBUG HELP
none of then worked.
 
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.
 
Back
Top