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

Complicated VBA report... help

Path	csiph.com!weretis.net!feeder6.news.weretis.net!feeder.erje.net!2.us.feeder.erje.net!newspeer1.nac.net!border2.nntp.dca1.giganews.com!nntp.giganews.com!buffer2.nntp.dca1.giganews.com!buffer1.nntp.dca1.giganews.com!nntp.newsgroupbanter.com!news.newsgroupbanter.com.POSTED!not-for-mail
NNTP-Posting-Date	Mon, 14 Nov 2016 19:49:02 -0600
From	Osmith32803 <Osmith32803.12701f08@excelbanter.com>
Newsgroups	microsoft.public.excel.programming
Subject	Complicated VBA report... help
Date	Tue, 15 Nov 2016 01:42:21 +0000
Message-ID	<Osmith32803.12701f08@excelbanter.com> (permalink)
Organization	ExcelBanter.com
User-Agent
X-Newsreader
X-Originating-IP
Lines	40
X-Usenet-Provider	http://www.giganews.com
X-Trace	sv3-yrJxm6sy4uDouT/+BXYa817/JYMOy+KU7dcLgAvtvoxzcscCIBHIh0i93iH23QHnBgQZV9+JXLqyq06!2ELSyIp5+gDUEwX5xLt3XPbj/l6snpL32C1NlqO1h26K9xlPMmN94M3zoSKkm0j555kaCOmcJfNH!14izkF/1UXWTmg==
X-Complaints-To	abuse@newsgroupbanter.com
X-Abuse-and-DMCA-Info	Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info	Otherwise we will be unable to process your complaint properly
X-Postfilter	1.3.40
X-Original-Lines	18
X-Original-Bytes	2242
Xref	csiph.com microsoft.public.excel.programming:109580

Show key headers only | 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