Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summarizing Data
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. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "John" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summarizing Data
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 "Gary Brown" wrote: 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. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "John" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summarizing Data | Excel Worksheet Functions | |||
summarizing data | Excel Worksheet Functions | |||
Summarizing data | Excel Discussion (Misc queries) | |||
Summarizing data | Excel Discussion (Misc queries) | |||
Summarizing data | Excel Discussion (Misc queries) |