Filter Data on one sheet with dropdown list from another sheet

[used2reg]

I have an excel file with 3 Sheets - Dashboard, Funnel and DDL

The Dashboard is used to display the summed up data from the funnel sheet
The Funnel is used for user entry
DDL - is my sheet uses for drop down lists

What i would like to do is on the Dashboard sheet, add a drop down (which i have added) that i can only select one option: Q1-19, Q2-19, Q3-19, Q4-19, Q1-20, Q2-20, Q3-20, Q4-20, etc and it would filter my list on the Funnel page (there is a drop down here that the user would select the Quarter - its in Column K); so that the filtered data on the Funnel page only displays what is selected in the drop down on the Dashboard sheet.....

VBA is fine is possible..

Thanks

 

[Fluff]

Maybe something along the lines

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.CountLarge > 1 Then Exit Sub
    If Target.Address(0, 0) = "K1" Then
        If Target.Value = "" Then
            Sheets("Funnel").Range("A1:K1").AutoFilter 11
        Else
            Sheets("Funnel").Range("A1:K1").AutoFilter 11, Target.Value
        End If
    End If
End Sub

This needs to go in the Dashboard sheet module. Change ranges & sheet name to suit

 

[used2reg]

I must be missing something - does not seem to do anything for me..

The drop down on the Dashboard page is used to pick the Quarter that i wish to see and its in D8; and that selection i need to filter on the Funnel sheet (more funnel sheets will be added also for my additional sales people - funnel2, funnel3, funnel4...) is in column K (K2:K1000)

 

[Fluff]

Did you change the ranges & sheet name to suit?

 

[used2reg]

i believe its now working.

Thanks

 

[Fluff]

You're welcome & thanks for the feedback