Hello,
I have data table and created pivot using it. Is it possible to update the pivot table when I filter in Data table?
If I filter Jan in the Data Table of sample file, it should show only the pivot for the month of Jan. I dont want to filter it in Pivot Table.
Any help will be appreciated..
Regards,
Humac
Is there any particular reason why you do not want to filter in the pivot table directly?
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]
There is no particular reason. If I have 10 Columns and if I filter with any one of the column (even not in pivot Field List), I want the pivot to adjust according to the data Table.
I method i can think of is -
Have a hidden sheet where the filtered data from the main data sheet is copied (through macro) into this hidden sheet.
Base your pivot on the hidden sheet.
Can you please provide me the sample code, so that I can test it?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks