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?

	A	B	C	D	E	F
1	Date	Time	Name	Place	Colour	Order
2
3

<tbody>
</tbody>

 

[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.