Excel VBA Auto-filter Based on Values of Another Cells Posted on April 23, 2021April 24, 2021 by Summa Lai I and was trying to filter the data based a couple of cell values. Finally, I figured it out. Below, please see my sample. Filler Sheet “Trans” based on the values of C3, C5 and C6 from Sheet ” Reports”.