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