Totals and Sorting
 

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

Totals and Sorting
 

Tim,

You need to set up your data as a true database, where Project is a column
filled in with X, etc.

Instead of

Project X
Emp Hours
Tim 6
Tom 12

use

Emp Project Hours
Tim X 6
Tom X 12


Then you can simply do a Pivot Table, and get all those details. View Help
on Pivot Tables, and you should get a good start.

HTH,
Bernie
MS Excel MVP


"Txsg8r" wrote in message
...
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