Hi,

I wish to apply autofilter on one of the fields with multiple criteria from a different sheet.

I have a table with multiple columns and one of them is years. I want to apply filters to 3 different columns, but for the year column I wish to give a range of values to the filter (2022 to 2025).

My code looks like this:

ws.Range("A1:s1000").AutoFilter Field:=1, Criteria1:=sourcesheet.Range("A57").Value
ws.Range("A1:S1000").AutoFilter Field:=5, Criteria1:=sourcesheet.Range("B57").Value
ws.Range("A1:S1000").AutoFilter Field:=7, Criteria1:=sourcesheet.Range("C57").Value

In the 3rd criteria, "C57" refers to value of 2022 in the source file but I want to include c57 to c60 to include 2023, 2024, 2025 in the filtered value.

Would really appreciate some help on this.

Thanks!