Filter based on cell value from another worksheet

[thedeadzeds]

Hi Guys,

Is there a way to use the auto filter based on a cell value from another sheet.

I would like to filter column P in the "Data" worksheet based on the cell value in G1 in the "Main" worksheet.

Thanks

 

[Burrgogi]

Replace the the word "test" with the actual word in cell G1.

Sub Create_Autofilter()
    If Worksheets("Main").Range("G1").Value = "test" Then
         Worksheets("Data").Range("P:P").AutoFilter
    End If
End Sub

 

[Burrgogi]

Slightly modified for error handling:

Again, same as before. Replace the the word "test" with the actual word located in cell G1.

Sub Create_Autofilter()
If Worksheets("Main").Range("G1").Value <> "test" Then
    MsgBox ("Cell G1 in 'Data' Sheet does not meet the criteria for autofilter!")
    Exit Sub
Else
     If Worksheets("Main").Range("G1").Value = "test" Then
          Worksheets("Data").Range("P:P").AutoFilter
          MsgBox ("Autofilter successfully applied to column P in the 'Data' worksheet.")
     End If
End If
End Sub

 

[Trevor G]

Is the data formatted as a table? If so you could try adding a slicer to apply the filter from another sheet.