Filtering of data - autmatically based on data on other sheet
 

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.

Filtering of data - autmatically based on data on other sheet
 

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


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"uptonfamilywa" wrote:

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.