Filter but keep certain headings rows?

[swithin]

I have a problem in relation to filters in excel. I have a list of about 2000 rows, with the rows being divided into four sections. I want to filter all columns. When i use 'Autofilter' in excel it removes the rows which give the section name once a value has been selected.


So in other words, when the data is filtered i want the 4 section headings to remain at all times. Is there any VB code that will achieve this. Thanks in advance.


Regard,

Eoin Walsh


e.g.
section 1 (row 1)
row 2
row 3
row 4
section 2 (row 5)
row 6
row 7
row 8
section 3 (row 9)
row 10
row 11
row 12
section 4 (row 13)
row 14
row 15
row 16

[royUK]

Sorry, AutoFilter doesn't work like that.

[swithin]

Would it be possible to put some code into VB to say,
"where row = 'section 1' do not filter/remove"

or

perhaps i could create a macro that would insert these dividing rows once some one selects from a drop down arrow on a filter.?


excuse my ignorance!

thanks in advance

Eoin

[royUK]

It would be easier to design you worksheet to fit the AutoFilter requirements. can you attach a zipped workbook?

[swithin]

I have attached an example zip file. I had to remove some information for confidentiallity but you will get the idea. If i select 'Tom' from the Name column i want the header rows '91+ DPD' 61-90 DPD' etc to stay in place.

Thanks look forward to hearing from you.

[royUK]

The best approach would be to add a column for the DPD, then create a PivotTable.