Autofilter certain worksheets when workbook opens

[Katy Jordan]

Hello, i would like to autofilter two worksheets when the workbook opens, Sheet 1 and Sheet 2, data or heading for both sheets start at A11 to C11, i would like the macro to filter Col C >=90.

 

[VoG]

Try this. Right click the Excel logo just to the right of File of the menu bar, select View Code and paste in

Private Sub Workbook_Open()
Sheets("Sheet1").Range("C:C").AutoFilter Field:=1, Criteria1:=">90", Operator:=xlAnd
Sheets("Sheet2").Range("C:C").AutoFilter Field:=1, Criteria1:=">90", Operator:=xlAnd
End Sub

 

[Katy Jordan]

Fantastic it works perfectly, thankyou VoG

Try this. Right click the Excel logo just to the right of File of the menu bar, select View Code and paste in

Private Sub Workbook_Open()
Sheets("Sheet1").Range("C:C").AutoFilter Field:=1, Criteria1:=">90", Operator:=xlAnd
Sheets("Sheet2").Range("C:C").AutoFilter Field:=1, Criteria1:=">90", Operator:=xlAnd
End Sub

 

[VoG]

Meg nytelse.

(I hope that translated correctly!)

 

[Katy Jordan]

what language is that? i am thinking it means you are welcome

Meg nytelse.

(I hope that translated correctly!)