Data filter only some columns

[BravoBravoAu]

Hi guys - grateful for any assistance you can give. I have done this before via VBA but can't recall exactly how.

I have a worksheet with various headings, as below. I want to have data filters available on some headings, but not others. For instance: Columns A, C, D & F, but not visible on B and E.

Any ideas?

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date[/TD]
[TD]Time[/TD]
[TD]Name[/TD]
[TD]Place[/TD]
[TD]Colour [/TD]
[TD]Order[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

See if this might help you.

 

[BravoBravoAu]

Thanks @Peter_SSs - this a great solution. Its not the same as I've used in the past, but its neat.

Thanks for your asistance, apologies for the delay in responding.

 

[Peter_SSs]

No problem - glad to help.