Ok, here's the skinny:
We have a project status excel workbook that everyone updates via a shared drive. Very inefficient, as you can imagine.
Being the case, I would like the individuals to update their "own" workbook and have this data populate the "parent" workbook (including the addition of rows, not columns).
i.e. The parent workbook contains no data except the header cells. The data could then be filtered using auto filter.
Example:
Parent workbook has header columns:
Project Owner Status
All other workbooks have same header configuration.
Buffy enters her status information in her workbook; Otto enters his information in his workbook.
Our manager Biff, opens up the parent workbook and sees the data we entered and is able to filter this data via auto filter of the header columns (e.g. He wants to just see my projects).
Suggestions?
Great forum, by the way
We have a project status excel workbook that everyone updates via a shared drive. Very inefficient, as you can imagine.
Being the case, I would like the individuals to update their "own" workbook and have this data populate the "parent" workbook (including the addition of rows, not columns).
i.e. The parent workbook contains no data except the header cells. The data could then be filtered using auto filter.
Example:
Parent workbook has header columns:
Project Owner Status
All other workbooks have same header configuration.
Buffy enters her status information in her workbook; Otto enters his information in his workbook.
Our manager Biff, opens up the parent workbook and sees the data we entered and is able to filter this data via auto filter of the header columns (e.g. He wants to just see my projects).
Suggestions?
Great forum, by the way