I have a spreadsheet with approx. 100 rows and 50 columns showing Employees
down and various categories across such as hours, rates, etc.
This is split out by Project. So, what I see is Project X with all
employees under that and the fields mentioned above all totalled for the
project.
The employees show up for many different projects, but I cannot total those
up as well.
What I am looking for is a way to show (on a new worksheet) the detail and
totals BY EMPLOYEE listing the project and the pertinent hours above.

Is there a way to do this inherent in excel, or will I have to use VBA
coding? I am proficient in VB and VBA in other MS Apps, but don't know the
best way to do this in EXCEL.

PLEASE HELP!

Thanks.

Tim