How to sort pivot table?
I will appreciate advice on how to sort a desired pivot table column field
in VBA. I tried Sort method, but VBA help is very unclear on how to use it with pivot tables. What should be "key1" in this case? Thanks in advance - RADO |
How to sort pivot table?
You have to sort the table based on the value in a row field.
-- Regards, Tom Ogilvy "RADO" wrote in message ... I will appreciate advice on how to sort a desired pivot table column field in VBA. I tried Sort method, but VBA help is very unclear on how to use it with pivot tables. What should be "key1" in this case? Thanks in advance - RADO |
All times are GMT +1. The time now is 01:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com