Hello,
when a filter in a PT is created, Excel automatically locates it in position A1:B1.
Is there a way to make it appear in anoter position (i.e. A20:B20)?
Do you know also how to make Excel feel a Change Event in case the value of the Pivot Filter (displayed in B1) is modified?
Thanks
Regards
Last edited by BrianAll; 09-20-2017 at 11:09 AM.
AFAIK there is no possibility to change location of filetr(s) except A1,A2 or A1, C1
Thanks.
What about the chance to make the Change feels that the displayed filter value (B1) has been modified?
There are two questions: 1st - filter(s) location, 2nd - change event (probably vba)
for the 2nd you need to wait for VBA-men
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks