I have a pivot table with the right format i wanted. However when i click the number in the pivot table, a new tab appear but not with the right format. How can the new tab share the same format as the pivot table ? Thanks in advance for helping me
I have a pivot table with the right format i wanted. However when i click the number in the pivot table, a new tab appear but not with the right format. How can the new tab share the same format as the pivot table ? Thanks in advance for helping me
You mean when you double click on any entry in the pivot, you get a separate worksheet with the details of that entry?
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]
Yes , when i double click , a separate sheet pop up. But the formatting is different from the pivot table . How to maintain the same formatting ? especially the pop up sheet has many decimal place
I dont think you can change the formatting of the sheet that comes out of the pivot. However, you can have a small code written that can format it the way you want.
you mean VBA programing ? Anyway thanks for your info provided .
Yeah. You can outline whatever formatting is required. You can even record those activities and then modify & cleanup the code. We can help you as well.
Thanks .. VBA is too much for me. I will give it a pass
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks