Filter and Print help

[vsravi.kmb]

I have a excel sheet having 12 columns and more than 1000 rows. I want to print by filter on a particular column, say for example, column J. Column J having data north, south, east and west. I want to print the excel sheet that column J having only north and I want the report header shows "NORTH" or somewhere in the top row of the sheet. I have numbered 1 as north, 2 as south, 3 as east and 4 as west. If I type 1, that the column J needs to be filtered by north and the title shows as north, something like this I want. Any help please Is there any simple way just one click that shows the title as north and filter the column J only north. Hope my request is clear.

[HaHoBe]

Hi, vsravi.kmb,

how should that macro be triggered? Do you use a Data/Validation to trigger which item to be fiöltered? Should the region be put into the Naeder or into a repeated row above the range?

You should consider to attach a sample workbook showing situation as is on one worksheet and result as wanted on another without any confidential information.

Ciao,
Holger

[vsravi.kmb]

Hi, vsravi.kmb,

how should that macro be triggered? Do you use a Data/Validation to trigger which item to be fiöltered? Should the region be put into the Naeder or into a repeated row above the range?

You should consider to attach a sample workbook showing situation as is on one worksheet and result as wanted on another without any confidential information.

Ciao,
Holger

I need simple Advanced filter formula.

For example if I type "test" in cell A3, I need the table filtered by column say D having values test, testing, tested, under testing etc...

Same also i need for numbers stored as text

Thanks