Summarizing Data

[John]

I am building a project workbook that contains, among other sheets, a summary
sheet for each of several projects we're working on. These summaries are all
formatted similarly and contain a table of open action items for the
applicable project. Each row in a project AI table identifies the action, who
is responsible, status, due date, etc. Some tables are large, some are empty.

How to I create a table on a separate worksheet for each individual that
lists all of the action items they are responsible for across all projects?

Sure appreciate your help, John

 

[Gary Brown]

why don't you combine all your various worksheet databases into one worksheet
database. Add a column so each row of data identifies the specific project.
Now, use filtering to view individual items / individuals and/or use a Pivot
Table to view them.

 

[John]

Great idea, but my boss wants separate spread sheets for projects and
employees. He's been doing it this way by hand and is getting tired of
copying rows from individual project sheets to each employee sheet.

I'm thinking this may need to be some sort of a macro or VB script, but I
was hoping there was some db or table function that would yank all the rows
from a sheet for a particular employee and add them to a table on the
employee sheet. Maybe I should be asking this in the Excel programming forum.

Appreciate your help, John