ken
firstly, Welcome to the Chandoo.org Forums
I prefer to use a non-vba technique I documented in my 2nd post here:
http://chandoo.org/wp/2010/02/02/da...lumn-with-duplicate-entries-as-a-source-list/
The data is in Excel-formatted tables, not pivot tables. And I wish I could use a "slicer", but unfortunately, my company is still on Excel 2007. I hear that we're moving to 2013, but not in the near future (maybe next year...).Hi
Not sure if I understood you right but If you feel that the data can be converted to pivot tables then you can use the slicer function for the "Project" identifier and drop down on 1 sheet and it will automatically do for all the rest connected to that slicer.