I got a Question.... Hope someone can help me to solve...

I had do 1 userform that get entries from users. I will get their nam
and project that they handle and the hours they spent for the project.

For example, I get 5 entries, which a
Name Project Hours
Dan A 3
Upls B 5
In A 5
Kon B 2
Kasn C 3

Well, after I get this entries, I will sort them base on the projec
name. My question is how we gonna to calculate the total hours fo
project A, project B and Project C? Since I dunno how many entries wil
be made by users(either 2 projects, either 4 projects...and it is no
fix) I cannot have total1 = project A, total2= project B..... Is ther
any method to calculate the total for each projects

--
Message posted from http://www.ExcelForum.com