Filtering

[JB]

Hello,

Is there a way to only us the auto filter on specified columns????

Thanks,

JB

 

[Ron de Bruin]

Hi JB

Do you mean that you don's see the other arrows ?
Look here
http://www.contextures.com/xlautofilter03.html#Hide

 

[PegL]

If they're contiguous, you can select the columns you want to filter and
select auto filter.

 

[JB]

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

 

[Dave Peterson]

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