how to generate individual reports?

[RalphReinbeck]

Hello. I'm a teacher, and I've got a few spreadsheets
that list grades for my students. I'd like to generate
individual reports for each student -- that is, instead
of handing out ten spreadsheets, I'd like to hand out one
report to each of ten students with only the appropriate
information on each.

If possible, I'd like to take my grades (listed
horizontally in rows) and put them in a single (or maybe
two) column(s) that read down the individual report.
It'd be nice if the report had the student's name at the
top, and it'd also be nice if I could somehow change my
existing column headings (abbreviated E1, Q1, etc. for
Exam, Quiz) to the actual words Exam, Quiz, etc. when the
report prints.

My data appear in my existing worksheet as

Name | HW1 | ... | Q1 | ... |E1|...

I have searched and browsed on here, but I wasn't sure if
my search words were generating the appropriate results.
I appreciate any help or information that might be out
there -- thanks a lot!

R

 

[Bernard Liengme]

Ok, Ralph, its homework time!
The feature you need is Mail Merge but it is in Word not Excel. Mail Merge
uses two files. The template sets out the format of the resulting pages
(Word doc). The data file holds the data (Excel)

I suggest you locate a book on Word and lookup Mail Merge. UI will be happy
to help when you have mastered the basics.

Can you tell we have the same profession?

Bernard
www.stfx.ca/people/bliengme

 

[Dave Peterson]

It sounds like you're handing out pieces of paper.

If that's true, then maybe you could insert a new worksheet.
Select your data
go to A1 of the new sheet
Edit|paste special|check transpose

Now you have categories down column A and names across row 1.

File|page setup|sheet
columns to repeat at left (point at column A)

Then select column B and file|print|Selection (at the bottom left)

then column C, then D, etc.

(and I wouldn't bother with the Q1 becoming Quiz1--but if you really care, maybe
select column A and Edit|Replace
Q
with
Quiz
(replace all)

E
with
Exam
(replace all)

Do them in a nice order so you don't get a mass change you don't want.

(Maybe
replace Q with QQQQ
E with EEEE
HMW with HHHH

and then come back and change the unique QQQQ, EEEE, HHHH to the nice names.

 

[Peter]

This mail merge system is available inside MS-Excel itself
with a very easy to use add-on. It's a new one I think.
On www.admisoft.com, find printData

Peter

 

[RalphReinbeck]

Hello all -- not sure if you'll see this, but thanks for
the help. This is just what I'm looking for.

Thanks again,
R