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

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

Complicated VBA report... help

Show all headers | View raw

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

Back to microsoft.public.excel.programming | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

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

csiph-web