Hello, need help for change filter pivot table on selected pivot table,
i have code from my friend and i think it can be simplified Thanks before
Please Login or Register to view this content.
Hello, need help for change filter pivot table on selected pivot table,
i have code from my friend and i think it can be simplified Thanks before
Please Login or Register to view this content.
Welcom to the forum,
You have 5 identical blocks of code, differing only in the number in "PivotTableXX", where "XX" is the number. So you can use a loop with a changing counter, which is the numbering source for "PivotTableXX", e.g.:
Please Login or Register to view this content.
Last edited by fiqarcobel; 05-05-2019 at 11:53 AM.
Ad 1.
If you want to have more flexibility with the name of the sheet changing, its name should be passed to the code by a constant or variable that stores that name, for example:
Ad 2.Please Login or Register to view this content.
Question too inaccurate, general, of the kind of these, I quote: "what needs to be done to make it right ?" or "What should we do to make us feel good ?".
The answer can also be general: "You have to do a lot".
It would be necessary to first determine what kind of discontinuity is there and if is there any repeatability, some kind of scheme or not ?
Give examples ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks