filter multiple columns simultaneously using Vbscript

[satish.nl]

Au
10
63
1888


Ad
11
50
555


Au
10
51
888


Ad
10
63
222


Au
11
55
8798




hi my table looks similar to the above

i have to filter first three columns at the same time

after applying filters for first two columns, im not able to filter the third column using the required data,
required data in third column is hidden after applying filter for the 2nd column, my method for filtering data is


With ActiveSheet

.Cells(1).AutoFilter 1, "Ad"
.Cells(2).AutoFilter 4, 11
.Cells(3).AutoFilter 3, 63




please suggest me few ideas in sorting the issue


Thanks in advance
Satish

[Paul_Hossler]

1. VBscript is something different than VBA = Visual Basic for Applications

2. A group of filters like that usually AND together and only list the rows that meet all the criteria. Are you looking for row that have "Ad" in column 1 OR 11 in column 2 OR 63 in column 3?