Totals and Sorting

[Txsg8r]

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

 

[Bernie Deitrick]

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