View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default autofill handle rows to coulmns

My biggest thing is they get all the data with only there score not
all
the canidates scores and that it fits on one page and is readable and
not all mashed together. i would greatly appreciate any help in being
pointed in the right direction.


This will probably require VBA. My student grades manager app mentioned
in my other reply prints out reports for selected students or the
entire 'class', each on a separate sheet. The sheet also allows
filtering student data for a single student so the scores can be
viewed/discussed directly with the instructor without the other student
data viewable. Perhaps you can do similar!

During my reworking of your project it seemed likely that it would be
worth trying out in that app. The format is school-based in that it
returns PointAvg, letter grade, and percent avg based on a GradesTable.
I might try your project to see how it fits in. The obstacle as I see
it is going to be handling the 3 judge gradings, but 3 rows per student
will definitely work similar to my rework sample. I give it a whirl and
report back...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion