Filtering data within macros

R

robert_woodie

I have a spread sheet with 6 coloums of data such as name,month,job.
have filters so i can see how many jobs are done in a month or how man
jobs one person is doing. I would like to be able to write a macr
which works out most of the combinations of filters and outputs it t
a seperate sheet. There are lots of different options for each coloum
tho! Is there any quick ways i can do this other than reseting th
filters everytime for every combination?

hope i have explained this ok....its even confusing me!!

Cheers
Robert
 
D

Don Guillett

This may be helpful

Sub PartsFilter()
Application.ScreenUpdating = False
With Sheets("Parts")
x = .Cells(Rows.Count, "b").End(xlUp).Row
.Range("A4:D" & x).AutoFilter Field:=1, Criteria1:="<>"
Application.Goto Range("a5"), Scroll:=True
End With
Application.ScreenUpdating = True
End Sub

Sub PartsUnfilter()
Application.ScreenUpdating = False
Sheets("Parts").Range("a4:d4").AutoFilter
Application.ScreenUpdating = True
End Sub
 
Top