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?