I'm having an issue witth the types of changes you plan to make with the
Enter worksheet. The formating changes wil be a problem. Maybe I should
only copy the values of the cells from the enter to the new worksheet to
avoid problems. What happens if somebody adds a new row into the ENTER
worksheet?

I think your problem is if I put a check in the box and you perform the
check yo don't wnat to have to go back each time and verify all the checks.
Maybe I should only write checks into empty cells and not ones you modified
manually.

"iMAN2" wrote:


Hi,
the attached file is exactly what the real one looks like. The inital
problem with the coding was that lets say i moderated it and it made the
'moderated - marks' sheet. However, if i changed same data in the
'enter' marks sheet and then re-exported, instead of updating the data
it would create a new sheet (which i don't want).

If a mark to compare against in the moderation table doesn't exist,
then only read 'check'.


Thanks


+-------------------------------------------------------------------+
|Filename: Moderate (New Format).xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=152|
+-------------------------------------------------------------------+

--
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