Please help me with a formule or a vba code to compare two pivots, results similar to the one I have attached in this email.
Thanks!
Please help me with a formule or a vba code to compare two pivots, results similar to the one I have attached in this email.
Thanks!
Can you upload exact pivots with dummy data? The getpivotdata function should help you. It can be done manually or even through macro.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Am sorry, but your data contains only alphabets. Its very difficult to work out a logic this way. Do you have better data that you can provide?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks