Tom Ogilvy posted some code for this in the following thread:
http://groups.google.com/groups?&thr...upernews.co m
ryssa < wrote:
Here is the code for the recorded macro for just a simple filtering.
Currently it is filtered for 2 out of 18 collumns. At different times
i would need to filter for more than 2 columns with multiple conditions
in a single colums eg. for companies A, B, C and D.
Sub MacroFilter1()
Selection.AutoFilter Field:=3, Criteria1:="sfg"
Selection.AutoFilter Field:=2, Criteria1:="sales"
End Sub
I am not good with using excel and do not know VB so thank you for any
help you can give.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html