help me if there is another way to do this

[lord_romel]

hello guys im new!! can you help me with a prob??

i work with excell and i generate report very primitively!! im thinking if theres a way i can do this faster??

well, this is a sample/small version of the excell sheet im working
here is a pic
http://img.photobucket.com/albums/v3...martin/001.jpg

that is the data and all i do to generate the report is filter them by program and get the autosum of each program
like shown in this link
http://img.photobucket.com/albums/v3...martin/002.jpg

so that means i filter the programs one by one to get the sum and retype each program in the next sheet and add the computed amount
like this
http://img.photobucket.com/albums/v3...martin/003.jpg

so im thinking is it possible to do it faster, cause the real sheet im working on has about 30 plus programs and it takes long to filter them one by one just to get the total and to retype each program again!!

thanks in advance