lists

[Librarian2be]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Hi,

I am working on creating a database of all the students intending to audition for my college's music department. I was wondering if there was a way to create a spreadsheet of all the students and their information so that I can click on their row and print out an individual sheet of student to hand to the faculty.
thanks!

 

[John_McGhie_[MVP]]

Yes, but Excel is not a good application to be doing this in.

Talk to your College IT department, you will find that they have a selection
of real database programs available for you to use, that will actually do
this job "properly" without all the constraints an Excel solution would give
you.

In the meantime, try creating a new worksheet for each student, then making
a list ion the first page with each name hyperlinked to its correct sheet.

Command + k to insert Hyperlinks, click one to jump to that sheet.

Hope this helps

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Hi,

I am working on creating a database of all the students intending to audition
for my college's music department. I was wondering if there was a way to
create a spreadsheet of all the students and their information so that I can
click on their row and print out an individual sheet of student to hand to the
faculty.
thanks!

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[CyberTaz]

FWIW, I agree with John that something of this nature would be better
handled by a database app. If you must or prefer to do it in Excel, however,
there's another approach worth considering. Use Excel for storing the data
but use Word for creating/printing the output format. Word provides a far
more appropriate arena for setting up the 'report'.

If you set the data up as a proper list in Excel you can create a Word
document similar to a form letter. You can then do a merge to insert the
applicant data into copies of the report... Either all at once, selectively
one at a time, or in batches based on common fields (such as strings, brass,
percussion) or other criteria using the Mail Merge Manager in Word.

HTH |:>)
Bob Jones
[MVP] Office:Mac