Hi guyz,

I'll just give a quick run down of what i really need. Sample data is
attached.

Sheet 1 - Enter Marks
Sheet 2 - Moderation Comparison
Sheet 3 - Moderated marks (output)

Data is inputted into sheet 1. The marks for each respective subject
need to be compared against the table in sheet 2. This new mark is then
to be outputted in the respective columns in sheet 3.

Specific things needed: (text colour green in sample sheet for easier
reference)

If a subject contains the word 'accelerant' then for that name entry a
comparison shouldn't be made and the original mark should be kept as the
output mark. E.g. Chemistry

If there are mutliples of a subject for 1 entry, e.g. 2 physics then it
should return a pop-up error (stating for which name entry this
occured). If this is not possible, then in sheet 3 for the mark it
should read 'check'. An example of this is in sheet 3 for the last entry
in the sample data.

If for the comparison there is no comparison mark in sheet 2 to compare
the sheet 1 mark against, then the output mark in sheet 3 for that entry
should read 'check'.

Crosspost at: 'VBA Express Forum'
(http://www.vbaexpress.com/forum/showthread.php?t=26981)

Thankyou guyz for your help. :)


+-------------------------------------------------------------------+
|Filename: Moderator (Moderation Sample Data).xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=149|
+-------------------------------------------------------------------+

--
iMAN2
------------------------------------------------------------------------
iMAN2's Profile: http://www.thecodecage.com/forumz/member.php?userid=371
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=102545