Guest User

Untitled

a guest
Nov 21st, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2. ActiveWorkbook.Worksheets("Log").ListObjects("Table1").Sort.SortFields.Clear
  3. ActiveWorkbook.Worksheets("Log").ListObjects("Table1").Sort.SortFields. _
  4. Add Key:=Range("Table1[[#ALL],[Date]]"), SortOn:=xlSortOnValues, Order _
  5. :=xlAscending, DataOption:=xlSortNormal
  6. ActiveWorkbook.Worksheets("Log").ListObjects("Table1").Sort.SortFields. _
  7. Add Key:=Range("Table1[[#All],[Time]]"), SortOn:=xlSortOnValues, Order _
  8. :=xlAscending, DataOption:=xlSortNormal
  9. If Not Intersect(Target, Range("Table1[[#All],[Associate]]")) Is Nothing Then
  10. With ActiveWorkbook.Worksheets("Log").ListObjects("Table1").Sort
  11. .Header = xlYes
  12. .MatchCase = False
  13. .Orientation = xlTopToBottom
  14. .SortMethod = xlPinYin
  15. .Apply
  16. End With
  17. End If
Add Comment
Please, Sign In to add comment