Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Question 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 in an excel sheet:

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

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

Repeated for each student...

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 formulas, 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!

Last edited by Osmith32803 : November 15th 16 at 02:48 AM Reason: Formatting...
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Complicated VBA report... help

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Complicated VBA report... help Osmith32803 Excel Programming 0 November 15th 16 02:42 AM
Getting missing data from one report into another report... vlookupabyss Excel Discussion (Misc queries) 3 January 8th 08 04:26 PM
Automate Excel report to place certain data into existing report? Craig Harrison Excel Worksheet Functions 3 July 25th 06 01:54 PM
Header in Report Manager Report Steve K Excel Discussion (Misc queries) 0 March 7th 06 08:32 PM
Fill an individual report with values from a team report? alymcmorland[_4_] Excel Programming 2 October 13th 05 09:39 AM


All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"