combining fields for totals and new description on a new worksheet

[noraroe]

I have a worksheet with columns for, Name, SubCat, Type, Total(uncalculated amt)
I have another sheet with columns for SubCat, Dept

Example:
Sheet 1
Mr. Anonymous, 1040, Production Hrs, 141.2
Mr. Anonymous, 1040, Production Amt, 34930
Mr. Anonymous, 1040, Billed Hrs, 144.6
Mr. Anonymous, 1040, Milled Amt, 50615.34
Mr. Anonymous, 1040, Billed Adj Amt, 15031.84
Mr. Anonymous, 1041N, Production Hrs., .5

and so on for numerous SubCats
and then it starts over for a new Name

Final sheet is 3244 lines of information

Second sheet contains the grouping information for the final sheet - Example:
1040, Tax
1041N, Tax
AUD-G, Government Audit
Aud-C, Audit
Cal-B, Advisory

There are a total of 87 SubCat I need totaled to their respective Depts which total 5

How do I do this?

[arlu1201]

Hello noraroe,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.