Hi,

I'm trying to come up with either a table setting, formula, macro or pivot that will easily show pull the information of each responsible party on a separate tab pulling from a master listing is below and updating when chagnes are made to the master listing, basically want a tab for Jason, John, and Sara where it shows all of the tasks assigned to just them. So for John, it would pull all data within the rows related to "clean desk", "clear cabinet", Work on Project X", and "Work on Project Y" into another tab (one I could take out and send to that individual or see how their work stacks up), but if he got removed from review Project X (and Sara reviewed it instead and that was updated on the master listing tab), it would remove that from his tab. I feel there's a way to link the information and keep it live or have the ability to "refresh" those tabs but I haven't been successful at getting anything to work. I would like to not have external sources that are linked to locations on my harddrive (like using microsoft queries on external data), as this workbook would be sent via email and I believe that causes the links to break.

Test File.xlsx


Assignment Prepared by Reviewed by Date Started Date Complete
Clean Desk John Sara 1/13/2014 1/16/2014
Clear Cabinets John Sara 1/17/2014 1/20/2014
Work on project X Jason John 1/21/2014 1/24/2014
Work on project Y Jason John 1/25/2014 1/28/2014
Sleep Sara Jason 1/29/2014 2/1/2014