Hi All,
Is me again.. having some problems.
Do help me, thanks!

Trying to create something like this:
Let say I have a set of records running disorder from class
A,B,C,D,E,F,G,etc and marks range from 10,20,30,40,50. from years
2000,2001,2002,2003,2004,2005,2006.

Now, i trying to create a new table (mayb in a new tag) to store combine
total marks for that particular year for each A,B,C,D,E,F,G.


For example:

Class Date Makrs
A 5-aug-06 10
A 5-aug-05 20
B 5-aug-03 30
C 5-aug-02 30
D 5-aug-01 40
D 5-aug-04 20
G 5-aug-06 20
A 5-aug-05 30
E 5-aug-06 20
F 5-aug-04 40
G 5-aug-02 20
G 5-aug-01 50
F 5-aug-03 50

after sorting the table can look like this:


Year |2000|2001|2002|2003|2004|2005|2006|
-------------------------------------------------------
A
B
C
D
E
F
G
--------------------------------------------------------
Total
--------------------------------------------------------


any way just using the excel inside or do i have to use visua basic?