Data Sort Autofilter on different rows?

[geordicat]

I have Excel 2003 at work. I have a spreadsheet with different areas of information. The first few rows are one model of widget, then I have a few blank lines, then another group of information with another model of widget, blank lines.. group of widgets....

Across each set of data I have the headers, and the last column is for widgets within a specified date range.

Is there a way to have each row of headers have the Data Sort Autofilter arrows? Right now I have to highlight each header row and then click the arrow. If there was a way to have each little group have its own data sort arrow that would be way cool.

I hope that makes sense.



Thank you.

 

[venkat1926]

something similar to this macro

Sub test()
Dim r(1 To 3) As Range, j As Integer
Set r(1) = Range("a1").CurrentRegion
'MsgBox r(1).Address
Set r(2) = Range("A10").CurrentRegion
Set r(3) = Range("A20").CurrentRegion
For j = 1 To 3
r(j).AutoFilter field ..........
(your code for rest of what you want to do )
r(j).AutoFilter  ' to remove the autofilter
Next j

End Sub