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.