Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
Autofilter and IRM | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
AutoFilter | Excel Discussion (Misc queries) | |||
Autofilter and Not?! | Excel Discussion (Misc queries) |