VBA code to filter a column from a cell reference in a different worksheet

[dlamle]

I am wanting to create a filter for just Column AG in a worksheet titled "Darren" based off cell C8 in a worksheet titled "Control Sheet". The cell I want to reference is a value.

Below is the VBA code that I am currently using but every time I run the Macro is returns a message saying "Compile Error: Syntax Error" . Hopefully someone can help me out!

Sub Darren()
'


' Darren Macro
'


'
ActiveSheet.Range("$AG$2:$AG$2000").Autofilter Field:=33, Criteria1:=Worksheets("Control Sheet").Range("C8").Value.

 

[tannerboudrero]

What is the range of your data in the "Forecasts" tab?? And what column are you wanting to filter on it?

Thanks for the quick reply. The range of data in the Forecasts tab is $A$1:$0$2093. I'm wanting to filter Column A.

Thanks!

 

[dlamle]

Sub Filter_Sheet ()
ActiveSheet.Range("$A$1:$O$2093").AutoFilter Field:=1, Criteria1:="=" & Worksheets("Sheet1").Range("A3").Value
End Sub


This should work, let me know!

 

[tannerboudrero]

Sub Filter_Sheet ()
ActiveSheet.Range("$A$1:$O$2093").AutoFilter Field:=1, Criteria1:="=" & Worksheets("Sheet1").Range("A3").Value
End Sub


This should work, let me know!

It worked great, thank you!

I noticed that I have to have the "Forecast" tab selected for the macro to work. Is there a way to have a button on "sheet1" that will run the macro without having to select the "forecast" tab?

*update* In regard to my last question, I figured it out. Thanks again for your help!

 

[dlamle]

Yes!
-Click the developer tab
-Click Insert, and select the button (form controls)
-Create a box and assign the macro you created!

Everytime you click the button the macro will run