I need to sort Pivot Table data and post to another worksheet with all the details.
In a pivot table, it only list the catagory once on the first field. When I copy and paste so I can sort on the amount filed, it does not have the details which go with it. I need the reference to follow the amount.
I am new to Pivot Tables and there is probable an easy way to get the details to fill in each cell not just the heading.
Don’t have an account yet? Register yourself now and be a part of our community!