Hello,
I'm relatively new to using Excel functions and am looking for the best way to summarize data. Here are the facts:
There are multiple workbooks which represent company projects i.e., proj341, proj342 etc. Within these projects are multiple personnel identified individually. An employee may be contained in multiple project sheets. What I would like to do is set up a resource summary workbook that looks at all the various projects and identifies which individual is in each and then lists by individual which projects they are scheduled to work on. At the same time, I would like to be able to modify the projects on a realtime basis and see the change in the resource summary.
Any help with how best to proceed is greatly appreciated.
Brian
I'm relatively new to using Excel functions and am looking for the best way to summarize data. Here are the facts:
There are multiple workbooks which represent company projects i.e., proj341, proj342 etc. Within these projects are multiple personnel identified individually. An employee may be contained in multiple project sheets. What I would like to do is set up a resource summary workbook that looks at all the various projects and identifies which individual is in each and then lists by individual which projects they are scheduled to work on. At the same time, I would like to be able to modify the projects on a realtime basis and see the change in the resource summary.
Any help with how best to proceed is greatly appreciated.
Brian