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

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

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

--

Dave Peterson

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

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

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.

"Dave Peterson" wrote:

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

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

--

Dave Peterson

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

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

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

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

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





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

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 he
http://www.contextures.com/xlNames01.html

computexcel wrote:
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





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

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.

"Debra Dalgleish" wrote:

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

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





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