we are creating planning templates with multiple Input queries and analysis queries. my requirement is when ever user do some local filtering using "Analysis tab" the filter needs to be applied on analysis crosstab/Data sources. is this possible with VBA. if anyone came across these kind of scenario please advise. Thanks in Advance.