Hi, I need some help in VB, I have 2 pivot tables in one sheet, in both the pivots the report fileter section is same, what I looking is if I change the name in 1st pivot report filter section then in the 2nd Pivot it automettically change or get the data on the basis of 1st pivot report filter. Please help me in this, Thanks....