Romano_odK
Active Member
- Joined
- Jun 4, 2020
- Messages
- 379
- Office Version
- 365
- Platform
- Windows
Good morning,
In a pivot table calculated field its virtually impossible to autosort. Now I though if I would record the handling it could maybe be run everytime a change is made in the pivot table. Is that possible?
This is what I recorded.
Thank you for your time.
ActiveSheet.Range("$O$5").Sort Key1:="R5C15", Order1:=xlAscending, Type:= _
xlSortValues, OrderCustom:=1, Orientation:=xlTopToBottom
In a pivot table calculated field its virtually impossible to autosort. Now I though if I would record the handling it could maybe be run everytime a change is made in the pivot table. Is that possible?
This is what I recorded.
Thank you for your time.
ActiveSheet.Range("$O$5").Sort Key1:="R5C15", Order1:=xlAscending, Type:= _
xlSortValues, OrderCustom:=1, Orientation:=xlTopToBottom