Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109580 > unrolled thread

Complicated VBA report... help

Back to article view | Back to microsoft.public.excel.programming

Contents

  Complicated VBA report... help Osmith32803 <Osmith32803.12701f08@excelbanter.com> - 2016-11-15 01:42 +0000
    Re: Complicated VBA report... help GS <gs@v.invalid> - 2016-11-15 00:50 -0500

#109580 — Complicated VBA report... help

I'm trying to generate a report of student test data that shows student
performance broken down into four areas on a single test. Students must
take three different tests that each have four reporting areas.

I've been given a report that was generated in the past that has a
layout similar to this:

Student Name        Test Name        Report Area 
Sally.                      Test 1.             Area 1.1            
Area 1.2          Area 1.3
##.                
##.               ##
##.                
##.              ##

Test 2.            Area 2.1.            
Area 2.2.         Area 2.3
##.                 
##.                ##

John.                     Test 1.             Area 1.1.           Area
1.2.           Area 1.3
##.                 
etc.

I have the data set on separate sheets as it is generated by the testing
company, but I'm having trouble figuring out how to create an output or
sheet that has this type of format using formula, vlookups, queries,
vba, etc. Is it possible, without having to manually create these
miniature tables for the each student, to show all of their test data
for each test, including multiple attempts of the same test using vba
and macros?

Thank you for even making it all the way through this post!




-- 
Osmith32803

[toc] | [next] | [standalone]

#109581

Have a look here for *StudentGradesManager.xls*...

  https://app.box.com/s/23yqum8auvzx17h04u4f

..to see if it gives you any ideas!

-- 
Garry

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

[toc] | [prev] | [standalone]

Back to top | Article view | microsoft.public.excel.programming

csiph-web