Auto Filter Based On Cell Value
Closed
IzakG
Posts
3
Registration date
Monday January 12, 2015
Status
Member
Last seen
January 13, 2015
-
Jan 13, 2015 at 12:03 AM
IzakG Posts 3 Registration date Monday January 12, 2015 Status Member Last seen January 13, 2015 - Jan 13, 2015 at 04:59 PM
IzakG Posts 3 Registration date Monday January 12, 2015 Status Member Last seen January 13, 2015 - Jan 13, 2015 at 04:59 PM
Related:
- Auto Filter Based On Cell Value
- Grand theft auto 1 download - Download - Action and adventure
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Facebook auto refresh - Guide
- Nvidia drivers auto detect - Guide
- Auto redial - Guide
3 responses
Try this.
Copy the VBA into the Summary sheet code space.
Copy the VBA into the Summary sheet code space.
Private Sub Worksheet_Change(ByVal Target As Range)
Sheets("Budgets").Range("$A1:$AE6535").AutoFilter Field:=3, Criteria1:=Sheets("Summary").Range("C2")
Sheets("Budgets").AutoFilter.Sort.SortFields.Clear
Sheets("Budgets").AutoFilter.Sort.SortFields.Add Key:= _
Range("D1:D65535"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With Sheets("Budgets").AutoFilter.Sort
.Header = xlYes
.Apply
End With
End Sub
IzakG
Posts
3
Registration date
Monday January 12, 2015
Status
Member
Last seen
January 13, 2015
Jan 13, 2015 at 04:29 PM
Jan 13, 2015 at 04:29 PM
Thank you RayH,
I will try it today and give you feedback!
I will try it today and give you feedback!
IzakG
Posts
3
Registration date
Monday January 12, 2015
Status
Member
Last seen
January 13, 2015
Jan 13, 2015 at 04:59 PM
Jan 13, 2015 at 04:59 PM
Hi RayH,
I didn't work :( I get the following error!
The error is on the second line of code: "Sheets("Budgets")........"
I didn't work :( I get the following error!
The error is on the second line of code: "Sheets("Budgets")........"
