I have pivots tables that look up values in a worksheet based on a supplier's code number. Is it possible that when the supplier's number is selected in one pivot table that the identical field in the other pivot tables is auto-populated with this selected supplier number?