Hi. Can anybody offer me some words of wisdom on how to approach the
following...

I want to create a data entry worksheet that links to multiple
workbooks. To be more specific, the data entry worksheet is a school
class mark book with perhaps up to 30 students listed with their
grades entered into the relevent columns.

I then would like to send each row of information (student name and
grades) into the individual workbook for that student. The individual
workbook contains worksheets for a student for all year levels that
they are in over a 5 year period. The individual workbook is
basically a profile where all the grades are crunched to provide a
level of achievement.

The individual workbook that crunches the numbers works beautifully.
I am just trying to simplify data entry by developing a "mark book"
where the data is then placed into each workbook. It is a drama to
open each student workbook individually and enter data. Any
suggestions??

Greg