![]() |
Macro to synch three pivottables based on same data
I have three pivottables based on the same data. I need a macro that will
allow me to either type in two customer numbers in cells and all three tables pick them up or check off the Customer numbers in one table and have the other two pick it up. Would I need a piece of the macro to go in and clear the previous selection? Can this even be done? I will only be selecting two customers as it is a comparison thing. The list is extremely long (over 2000) so scrolling every time is very time consuming. |
All times are GMT +1. The time now is 07:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com