Filtering and Sorting in Excel 2010

[Chris Waller]

I am trying to filter some data on a Spreadsheet dependant on what I input into Cell J3. I would like to automatically filter the data and sort at the same time. I have some titles in row A20 to D20. The data in row B21 onwards should be the same as the info as what I input in cell J3, however, I would like to sort the data in row A21 onwards. I have a number of formulae on the top of the Spreadsheet that perform calculations (Subtotals) on a filtered list. I have tried several variations and I have looked on the Internet and for some reason I cannot get anything to work. I would be grateful for any help given.

 

[bhos123]

The easier way could be, sort the data before applying any filters... then apply the filters based on formulas linking to J3. This should give some help to you.

 

[Chris Waller]

Thanks for the tip, unfortunatley it doesn't help with my problem.

 

[Chris Waller]

I was trying to achieve this automatically on change to the data in J3.

 

[bhos123]

Sort your data and run the below code. change the range and the filter column number as per your requirement.

Sub filterProject()
Range("A1:E10").AutoFilter Field:=5, Criteria1:=">=" & Range("J3").Value
End Sub

 

[Chris Waller]

Sort your data and run the below code. change the range and the filter column number as per your requirement.

Sub filterProject()
Range("A1:E10").AutoFilter Field:=5, Criteria1:=">=" & Range("J3").Value
End Sub

Sorry it has taken a while to reply. I have just arrived home. I will give your suggestion a try tomorrow when I return to work. Thanks once again for your help.