I have set up a new spreadsheet with pupil's achievement levels in different
subjects. Each subject data is stored on a separate sheet. Each pupil has a
unique ID - which is on each sheet. Is there any way I can set up excel to
combine the results of one pupil acheivements in all subject areas. i.e. will
excel look on each separate sheet and locate the results for a particular
pupil - if so - how? Any help gratefully received.