Filtering of data - autmatically based on data on other sheet

U

uptonfamilywa

I have values on Sheet 1 that will trigger a value on Sheet 2. When I go to
Sheet 2 I want all fo the data automatically filtered (no manual interaction)
based on certain values.
 
S

Shane Devenshire

Hi,

If you actually want it filtered on a certain value you will need to write
VBA code.

Since you didn't supply any detail, I suggest turning on the macro recorder
and recording the steps you would do if you did it manually, then post the
code and tell us in detail what you want it to do.

here is sample code

Private Sub Worksheet_Activate()
Range("A1").Select
Selection.AutoFilter Field:=1, Criteria1:=Range("D1").Value
End Sub
 
Top