I have a VBA code from contextures that will allow me to select records from the report filter drop down box and apply that filter to any other report filter with the same field name. This is a very powerful tool but what I would like to do is to be able to combine multiple report filters from various pivot tables so the user can see all the possible attributes they can search by. For example: one pivot table report filter may contain the dates 1990, 1992, 1993 and another pivot table report filter may contain the dates 2005, 2006,2007. What i would like to do is to be able to combine these report filters so that the user would see all the possible selections (1990,1992,1993,2005,2006,2007)under one report filter drop down box.