Summarizing mutilple workbooks

[Socal996]

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

 

[babs]

If you don't want to use a code, try making up with some Gantt Chart Thing where you put all of your Sheet names in Columns and Name in the First Column. Then Use VLOOKUP or Find Formula to look for that name in the respective sheets - the resultant will be True or False. There you can count all True and get the desired result.