hi,

I have a master list of students (about 200+ )in one worksheet. On the
succeeding worksheets are the attendance for seminars. We have more than 20
seminars in a year. Because of the large no of attendees per seminar, I
usually type out a list of the students who came for each seminar, so there
will be 20 +attendance worksheets.

Not all students will come every time and there are new ones for each session.
To update on master list, I will sort each sheet by surname, print it out and
type in separate column (date) for each session and typed "P" for present
and "A' absent.

Is there a way to linked the data without printing each attendance worksheet?
A friend suggested that vlookup function will be applicable.
but my problem is some students in master list will be absent and some of
those who came are not yet in master list.

really appreciate your help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200912/1