View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default Summarizing Data

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