SHow filter in a header.

Hi,

Is it possible to show a filter in a Header.

Example:

Column H has a list of names i.e. Fred, Barney etc.

Is it possible that when you select all the Barney names in header (the left one) shows the wording "Filter: Barney" ?

Just a thought only sometimes I have to filter and print off a sheet and the area with the names in does not get printed therefore a "Filter: xxx" would be quite useful.


Thanks in advance.

Maybe you can use an Advanced Filter like this: