Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Filtering
Hello,
Is there a way to only us the auto filter on specified columns???? Thanks, JB |
#2
|
|||
|
|||
You have to filter from A:C (you can ignore D if you want).
But you need to use some code to hide the arrow in column B. The link that Ron posted to Debra's site has some sample code. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm JB wrote: Here is an example of what I mean. I have data in columns A-D, but only want a filter on A and C. Is this possible . . . or do I have to have auto filter on A-D????? "Ron de Bruin" wrote: Hi JB Do you mean that you don's see the other arrows ? Look here http://www.contextures.com/xlautofilter03.html#Hide -- Regards Ron de Bruin http://www.rondebruin.nl "JB" wrote in message ... Hello, Is there a way to only us the auto filter on specified columns???? Thanks, JB -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box Filtering Macro | Excel Discussion (Misc queries) | |||
Sorting and filtering | Excel Worksheet Functions | |||
avanced filtering for latest date | Excel Discussion (Misc queries) | |||
Filtering | Excel Discussion (Misc queries) | |||
Using Filtering | Excel Discussion (Misc queries) |